Running Product Function

Case 24.

Tableau has many cumulative functions: RUNNING_SUM, RUNNING_MAX, RUNNING_AVG, and others. But among them, there is no such function as RUNNING_PRODUCT, which can often use to calculate indicators. But there is a way to implement it yourself.

Some RUNNING_PRODUCT function use cases

  • Calculate the total product of a given data set. For example, you could use this function in a sales report to calculate the total amount of items sold in a given period.
  • Calculate the average product of a given data set. For example, you could use this function to calculate the average number of items sold in an online store over a given period.

  • Analyze the performance of a given product over time. For example, you could use this function to compare the sales of a product across different stores or periods.

How to calculate the actual value equal to the product of the base value by the cumulative product of the percentage of change

Check our Tableau Public workbook for step-by-step instructions.
Tableau practice is the best way to develop your data visualization skills. Therefore, our team trains Tableau skills by solving additional tasks of varying complexity. Then we meet via Zoom and discuss all possible solutions.

We call it Tableau Challenges and invite you to participate!

Take your free
Tableau workbook

Leave your mail, and we will send you a workbook with the tasks and a link
to the solution registration page.
Enjoy experts' solution analysis with Vizuators team!
By clicking the button, you agree to the processing of personal data. We use it to stay connected. Read more