8. Variance

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.

Steps to configure Variance:

1. 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.

2. 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.

3. Once the variance is calculated, a variance icon is added to the items in the category, providing a clear visual indicator.

4. By default, negative variance is displayed. To view only positive variance, enable the Positive Variance toggle.

5. Customize the colors for positive and negative variances using the color picker.

6. 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.

Image 1: Variance config in Format pane

Image 2: Variance icon in Facet Filter

Image 3: Variance icon in Hierarchy Filter