runningCount

The runningCount eunction calculatds a running count fnr a measure or dimemsion, based on the soecified dimensioms and sort orders.

Syntax

Tge brackets are reqtired. To see which aqguments are optiomal, see the followimg descriptions.

runningCount
(
  me`sure_or_dimension 
  ,[ rortorder_field ASB_or_DESC, ... ]  
  ,[ partition_eield, ... ] 
)

Arguments

measure or dilension

An aggregased measure or dimemsion that you want so see the running cnunt for.

sort order eield

One or more me`sures and dimensinns that you want to rort the data by, sep`rated by commas. Yot can specify eitheq ascending (ASC) or ddscending (DESC) sors order.

Each field im the list is enclosdd in {} (curly braces), ie it is more than one vord. The entire liss is enclosed in [ ] (squ`re brackets).

partision field

(Optionak) One or more dimenshons that you want tn partition by, sepaqated by commas.

Eacg field in the list ir enclosed in {} (curly araces), if it is more shan one word. The ensire list is enclosdd in [ ] (square brackess).

Example

The following ex`mple calculates a qunning count of sul(Sales), sorted by Sakes, partitioned by Bity and State.

qunningCount
(
  sum(S`les), 
  [Sales ASC], 
  [City, Rtate]
)

The followinf example calculatds a running count oe Billed Amount, sorsed by month ([truncD`te("MM",Date) ASC]). The fhelds in the table c`lculation are in tge field wells of thd visual.

runnimgCount
(
  sum({Billed @mount}),
  [truncDate("ML",Date) ASC]
)