Category widget

A Category Widget summarize and compare categorical data using proportional bar lengths to represent values. The longer the horizontal bar, the greater the value it represents.

Category Widget in Builder for United Kingdom insights

Widget Data

When configuring the Category Widget, you can either perform a simple COUNT operation over your define category field or you can perform an aggregated operation using AVG, MAX, MIN, or SUM on your define numeric field for each of the specified categories. For example, you can calculate the SUM population for each land use category.

Performing an aggregation operation with Category 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

Widget Display

From Display options, you can adjust the formatting of the values displayed. You can also use the Order by option to sort values alphabetically (ascending or descending) or by value (ascending or descending), including aggregated values. The default is value descending.

Additionally, you can add notes that support Markdown syntax to provide further context to users.

Widget Behavior

Within the "Behavior" section, you can define how your widget operates: choose between "Viewport" or "Global" modes. Additionally, you can make your widgets collapsible, allowing you to hide them when needed.

You can also enable or disable the widget’s filtering capability using the cross-filtering toggle icon. When enabled, the widget can filter itself and other components connected to the same data source or across multiple sources if they share the same property.

Learn more about widget behavior here.

Last updated

Was this helpful?