add_calc_group_format
Create a format-switcher calc group that overrides how measures are displayed (currency, percent, scale) without altering the underlying measure value.
Instructions
Build a calc group whose items OVERRIDE the displayed format (a currency / % / scale switcher): each item keeps the value (SELECTEDMEASURE()) but reformats it via its own format string. items = JSON array of {name,formatString}. Creates the calc group on table if absent.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| items | Yes | JSON array of {name,formatString}, e.g. [{"name":"Currency","formatString":"$#,0"},{"name":"Percent","formatString":"0.0%"}] | |
| table | Yes | the table to host the format calc group | |
| sessionId | Yes | ||
| precedence | No | calc-group precedence (optional) |