runningAvg
The runningAvg function calculates a running average for a measure based on the
specified dimensions and sort orders.
Syntax
The brackets are required. To see which arguments are optional, see the following descriptions.
runningAvg (measure,[ sortorder_field ASC_or_DESC, ... ],[ partition_field, ... ])
Arguments
- measure
-
An aggregated measure that you want to see the running average for.
- sort order field
-
One or more measures and dimensions that you want to sort the data by, separated by commas. You can specify either ascending (
ASC) or descending (DESC) sort order.Each field in the list is enclosed in {} (curly braces), if it is more than one word. The entire list is enclosed in [ ] (square brackets).
- partition field
-
(Optional) One or more dimensions that you want to partition by, separated by commas.
Each field in the list is enclosed in {} (curly braces), if it is more than one word. The entire list is enclosed in [ ] (square brackets).
Example
The following example calculates a running average of sum(Sales),
sorted by Sales, partitioned by City and
State.
runningAvg ( sum(Sales), [Sales ASC], [City, State] )
The following example calculates a running average of Billed Amount,
sorted by month ([truncDate("MM",Date) ASC]). The fields in the table
calculation are in the field wells of the visual.
runningAvg ( sum({Billed Amount}), [truncDate("MM",Date) ASC] )
