add_running_total
Creates a running-total measure from a base measure, using a date column for cumulative totals or a sort column for generic/Pareto running totals.
Instructions
Generate a running-total measure. Provide dateTable+dateColumn for a date cumulative, OR sortColumn (Table[Column]) for a generic / Pareto running total.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | home table | |
| dateTable | No | date table (omit when using sortColumn) | |
| sessionId | Yes | ||
| dateColumn | No | date column (omit when using sortColumn) | |
| sortColumn | No | generic sort column as Table[Column] (alternative to date) | |
| baseMeasure | Yes | base measure name |