KPI Tile: Comparative Tile

Check out the given walk-through on how to set the KPI Tile Comparative Tile chart properties.

A KPI Comparative Chart is a type of data visualization that displays key performance indicators and their corresponding values in a comparative manner. It is designed to showcase the performance of multiple KPIs side by side, allowing viewers to quickly compare their values and identify trends, patterns, and variations between different periods, categories, or entities.

Please Note: KPI comparative Tile compares one measure value against the other selected measure value.

Properties

The KPI Comparative Tile contains General Settings, View Filter, and Primary Value Axis like KPI Tile, but it has additional properties such as Show Trend, Secondary Value Axis, and Rule to insert comparative approach.

  • Navigate to the Design Workspace.

  • Select the KPI Comparative Tile component from the list of charts.

  • Drag a Measure value to the workspace from the selected Data Store.

  • The selected value appears on the workspace.

  • Open the Chart Properties tab.

  • The Chart Properties tab opens displaying the various properties for the KPI Comparative Tile chart. Set the required properties for the KPI Comparative tile using this tab.

General Settings

  • Exclude Global Filter: Use a checkmark in the box to exclude the Global filter conditions.

View Filter

  • Filter: Choose a view filter condition from the drop-down menu.

Label

  • Label: Insert text to be displayed as Label.

  • Label Font Size: Select the font size for the displayed label using the drop-down menu.

  • Label Color: Select the Label colour using the menu.

Primary Value Properties

  • Font Size: Select a font size from the drop-down menu.

  • Format Type: Select a desired format type from the drop-down menu (the provided options for this field are: None, Auto, Percent, Thousand, Lacs, Crore, Million, Billion, Trillion, Quadrillion).

  • Currency Type: Select a currency symbol to be displayed in the view (the provided options for this field are: None, Rupees, Euro, Pound, USD, Yen, Cent).

  • Precision: Set the after-decimal value (It displays up to 5 precision).

Secondary Value Properties

  • Provide the Secondary Value Properties to avail the second value for the comparison.

    • Secondary Value: Select a custom field from the drop-down menu.

    • Font Size: Select a font size from the drop-down menu.

    • Format Type: Select a desired format type from the drop-down menu (the provided options for this field are: None, Auto, Percent, Thousand, Lacs, Crore, Million, Billion, Trillion, Quadrillion).

    • Currency Type: Select a currency symbol to be displayed in the view (the provided options for this field are: None, Rupees, Euro, Pound, USD, Yen, Cent).

    • Precision: Set the after-decimal value (It displays up to 5 precision).

Trend

  • Navigate to the Trend properties option.

  • Show Trend: Use a checkmark in the box to display the trends.

  • Click the Rules icon.

  • The Rules window opens prompting the user to set new rules for comparison.

Please Note:

  • The Trend option appears, only after configuring the Secondary Value Properties.

  • The user can set multiple rules using the Rules configuration window.

Setting Rules

Follow the given steps to set Rules for comparison:

  • Once the user clicks on the Rules icon, the Rules window opens redirecting the users to set rules for displaying the comparative values.

  • Configure the required Rules fields, as shown in the following image:

    • Primary Operator: Select an option from the drop-down menu.

    • Operation: Select an operation from the drop-down menu to be applied as a condition on the selected Primary Operator.

    • Secondary Operator: Select an option from the drop-down menu.

    • Primary Color: Select a color for the primary value field.

    • Secondary Color: Select a color for the Secondary Value field.

    • Trend Direction: Select a trend direction using the drop-down menu.

    • Trend Color: Select a color for the trend icon from the menu.

  • Click the Apply option to apply the configured Rule.

Please Note:

  • Remove : Selecting this option removes the added rules.

  • ADD: Selecting this option adds a new row to be configured as a rule.

  • The Primary and Secondary values get displayed in the selected colors with Trend directed to upward if the rule condition is met.

  • The user can set multiple Rules by configuring the required fields.

  • Click the Add icon.

  • Set another rule where the Primary Value is selected as Greater than or equal to the Secondary Value, and the Trend direction is downward.

  • Click the Apply option.

  • The KPI Comparative Tile reflects the crucial changes when the conditions are met as per the set rule. ​

Last updated