Formula widget

Formula Widget allows you to derive Key Performance Indicators (KPIs) and metrics by performing operations directly from your source data.

Using Formula Widgets in Builder

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.

Provided aggregations in Formula Widget

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 using SQL Expression

Custom aggregation option in Formula Widget is not available for pre-generated Tilesets.

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.

Using display options to set formatting and add notes

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.