Formula widget
Last updated
Last updated
Formula Widget allows you to derive Key Performance Indicators (KPIs) and metrics by performing operations directly from your source data.
When configuring the Formula Widget calculations, you have the flexibility to choose in the Data section from a provided aggregation list or to set a custom aggregation.
The provided aggregation list options include COUNT, AVG, MAX, MIN, and SUM, offering a range of commonly used operations. When using these aggregation options, you simply need to specify the field from your data source that you want to aggregate.
For more complex and custom calculations, you can select the custom aggregation option to create your own SQL Expression. With this option, you can use a wide range of SQL functions, operators and syntax using single or multiple columns from your data source.
Custom aggregation option in Formula Widget is not available for pre-generated Tilesets.
From the Display options, you can set the format of the data displayed in the widget as well as adding notes which support Markdown syntax to provide further context your widget.
Within the Behavior section, you can define how your widget operates by choosing between "Viewport" or "Global" modes. Additionally, you can make your widgets collapsible, allowing you to hide them when needed. Learn more about widget behavior here.
