MicroStrategy ONE
Running count
Returns the running count for each value in a list of values returning the current count after each value. The count can be restarted based upon attributes identified in the parameter settings.
Syntax
RunningCount<BreakBy = {}, SortBy = ()>(Argument)
-
BreakBy is the attribute indicating where the calculation restarts.
-
SortBy is the attribute or metric by which the data is sorted.
-
Argument is a metric representing the list of values.
For additional information on and an example of this function, refer to the MicroStrategy Functions Reference.