CumCount / Computation Layer

Calculate the running count of non-null values in a column. Similar to pandas cumcount() or running count in SQL.

For each position i:

Applications:

  • Event occurrence tracking
  • Data completeness analysis
  • Sequential counting
  • Missing value patterns

Note: Counts only non-null values. Direction controlled by Reverse parameter.

Table
0
0
Table

Transforms

[, ...]

Select

column

The column to count cumulatively. Example with [1, null, 2, 3]:

  • Forward: [1, 1, 2, 3]
  • Reverse: [3, 2, 1, 1]
false

Controls counting direction:

  • false: count from top to bottom
  • true: count from bottom to top

Name for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.