8. Variance
Last updated
Last updated
Supported in: ❌Date Filter ✔️Facet Filter ✔️Hierarchy Filter ❌Alpha Numeric Filter
❌Numeric Filter
The Variance feature enables users to display KPI Variance Cards directly within the Facet and Hierarchy Filter as an icon in the user interface. This feature makes it easy to analyze and interpret data variances at a glance.
Add two measures to the Other Field. This will automatically enable the Variance section in the Format Pane, allowing you to configure variance using the first two measures added.
To customize variance settings, open the Variance Config section in the Format Pane. Select a measure from the dropdown to calculate variance based on the difference between the two measures.
Once the variance is calculated, a variance icon is added to the items in the category, providing a clear visual indicator.
By default, negative variance is displayed. To view only positive variance, enable the Positive Variance toggle.
Customize the colors for positive and negative variances using the color picker.
The configured variance is displayed in the Facet Filter for each item within a category. However, in the Hierarchy Filter, variance is only shown for the leaf-level nodes within the hierarchy.