v.Variance
Supported in: ❌Slider Calendar ✔️Year ✔️Multi Year✔️Month ✔️Month Range ❌Week ❌Day
The Variance feature empowers users to enhance their calendar visualizations by adding variance cards. These cards dynamically display variance data using green or red indicators, depending on the variance value, providing a quick and intuitive way to analyze trends and deviations.
Steps to enable Variance in Calendar:
In the Visualizations pane, add a Date field to the Category field well. Ensure the field is set to Date (not Date Hierarchy).
Open the Format Visual in your visualization settings.
Navigate to the Date Filter section. Locate and expand the dedicated Variance section.
Configure and customize the desired variance type based on your variance calculation requirements.
Set the Display Mode to Diff △ to show variance as a value, or to Diff △% to show variance as a percentage.
Ensure your calendar mode is set to one of the supported modes: Month Range, Month, Week, or Year.
Variance Type and their Configuration:
The Variance section provides the following options to calculate and display variances:
This compares the current period with the immediately preceding period. When
Steps to configure Period vs Previous Period
Open the Format Pane and expand the Date Filter section.
Navigate to the Variance section and select Calculation Type as Period vs Previous Period.
Choose the Variance Display Mode as either Diff Δ (absolute difference) or Diff Δ% (percentage difference).
The variance display mode will be indicated in the Week, Year, and Month selection panels of the Month Calendar.
For Month and Month Range calendar modes, only the red or green indication of variance will be shown.
Image 2: Period vs Last Period in Month Calendar
This Compares this period to the same period in the previous year.
Steps to configure Period Over Period
Open the Format Pane and expand the Date Filter section.
Go to the Variance section and select Calculation Type as Period over Period.
Choose the Variance Display Mode as either Diff Δ (absolute difference) or Diff Δ% (percentage difference).
The variance display mode will be indicated in the Week, Year, and Month selection panels of the Month Calendar.
For Month and Month Range calendar modes, only the red or green indication of variance will be shown.
This Compares two different measures and calculate the variance between them. Example: Compare Actual Revenue vs. Budgeted Revenue.
To configure this option:
Add two measures in the Others field. This will automatically configure and enable the Variance section in the Format Pane.
Go to the Date Filter and expand the Variance section.
Select Calculation Type as Between Measures.
Choose the Variance Display Mode as either Diff Δ (absolute difference) or Diff Δ% (percentage difference).
The variance display mode will be indicated in the Week, Year, and Month selection panels of the Month Calendar.
For Month and Month Range calendar modes, only the red or green indication of variance will be shown.
Image 4: Between Measures in Week calendar mode