add_time_intelligence_calc_group
Create a time-intelligence calculation group with Current, MTD, QTD, YTD, PY, PYTD, YoY, and YoY% measures. Set ordinals, a format string for YoY%, and model-level DiscourageImplicitMeasures.
Instructions
Create a time-intelligence calculation group on a table: Current/MTD/QTD/YTD/PY/PYTD/YoY/YoY% items with ordinals, a format-string on YoY%, and DiscourageImplicitMeasures set at model level.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | the (single-column) table that becomes the calc group | |
| dateTable | Yes | date table | |
| sessionId | Yes | ||
| dateColumn | Yes | date column | |
| precedence | No | precedence (optional) |