Knowledge Drop

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

Userlevel 5

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.                



0 replies

Be the first to reply!