running_total! (deprecated)
AQL Syntax: Evaluate measures along a running dimension with all data
This function will be deprecated soon and replaced by another function
Definition
Modify a measure into a running measure that accumulates values over one or multiple dimensions as it progresses. Note that the running total will be calculated on all data in the model ignoring any filter on the running dimensions.
To calculate a running total of only the data that is visible in the exploration, please use the running_total function instead. Here is a comparison between running_total and running_total!:
Syntax
running_total!(measure)
running_total!(measure, running_dimension, ...)running_total!(orders.total_orders, orders.created_at)
// with pipe
orders.total_orders | running_total!(orders.created_at | year())
// with multiple running dimensions
running_total!(orders.total_orders, orders.created_at, orders.status)Input
measure: The measure that you want to turn into a running measure.running_dimension(optional, repeatable): The dimension you want your aggregation to run along. If not specified, the returned measure will run along all dimensions that in your exploration
Output
New measure that runs along the specified dimension(s) with all data in the model ignoring any filter on the running dimensions.
Sample Usages
See the running_total documentation for sample usages.
running_total
AQL Function: Calculate a metric from starting of time (visible data by default) to the current period
period_to_date
Calculates a metric from the beginning of year, quarter, month, etc to the current date. For example, you can apply this computation to determine the total orders you have accumulated in sales from the beginning of the year up until the present date, also known as Year-to-Date(YTD) metric