Is it better to use the running_total measure or to use Table Calculations to perform a running_total?

Knowledge Drop

Last tested: Jan 21, 2019
 

This can vary on your use case; however, Table Calculations provide more flexibility as they are run after your the Explore page returns results.

This point is important to consider when your Explore results table has Pivoted Columns. Pivots will impact the Measure of `type: running_total`. In cases where a query is pivoted, running_total runs across the row instead of down the column. If this is not desired, add direction: column to the measure definition.

This content is subject to limited support.                

Version history
Last update:
‎04-05-2021 09:00 AM
Updated by: