Formula widget
Formula Widget allows you to derive Key Performance Indicators (KPIs) and metrics by performing operations directly from your source data.
Widget 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 and Aggregated grids based on Spatial Indexes.
Widget Display
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.
Widget Behavior
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.
Last updated
