Scripting functions can be used for operations on the visual such as showing or hiding columns, filtering data for a particular period, or setting a layout.
Layout functions:
| NAME | DESCRIPTION |
|---|---|
| DISPLAYTOAST | Displays custom text as a toast message |
| EXPORT | Creates PDF, Excel exports, or copies to clipboard |
| LAYOUT | Layout functions can be used to set the layout, set a theme, enable/disable rails, or expand the hierarchy to a particular level. |
| SETCFRULE | Enable or disable conditional formatting rules |
| SETFILTER | Apply or remove filters on the data |
| SETFILTERBYINDEX | Apply or remove filters based on the index of the filter |
| SETVISIBILITY | Show or hide rows, columns, and measures. |
| SHOWBETWEENPERIOD | Displays the data between the specified time frames |
| SHOWCLOSEDFORECAST | Display forecasts for previous periods |
| TOPN | Rank your data based on a category for a particular measure |
