KPI Comparative Tile

An Extended KPI Tile enhances a standard KPI by adding a secondary value, trend analysis, and conditional rules to highlight relationships and changes between two metrics.

A KPI Comparative Tile is a specialized visualization designed to display two key performance indicators (KPIs) side by side for direct comparison. It extends the functionality of a simple KPI Tile by adding secondary value support, trend analysis, and conditional rules. This makes it ideal for identifying patterns, variations, and directional changes between two related measures.

Unlike standard KPIs, the Comparative Tile highlights how one measure performs in relation to another, providing users with immediate insights into gaps, growth, or decline.

When to Use a KPI Comparative Tile

Use a KPI Comparative Tile when you want to:

• Compare two related KPIs (e.g., Target vs. Actual, This Month vs. Last Month).

• Show performance trends over time or across categories.

• Flag improvement opportunities through conditional rules (e.g., if Actual < Target, highlight red).

• This helps executives quickly spot variances without needing to dig into detailed charts.

Examples:

• Actual revenue vs. planned revenue.

• Current quarter’s churn rate vs. the previous quarter.

• Sales target achievement percentage with directional trends.

Chart Properties

General Settings

• Exclude Global Filter – Exclude the chart from global filters applied at the report level.

View Filter

• Filter – Apply conditions to restrict the dataset shown in the KPI (e.g., filter by region or product line).

Label

• Label – Text describing the KPI (e.g., Revenue vs. Target).

• Label Font Size – Choose label font size.

• Label Color – Define label color.

Primary Value Properties

• Font Size – Set the size of the primary KPI value.

• Format Type – None, Auto, Percent, Thousand, Lacs, Crore, Million, Billion, Trillion, Quadrillion.

• Currency Type – None, Rupees, Euro, Pound, USD, Yen, Cent.

• Precision – Up to 5 decimal places.

Secondary Value Properties

• Secondary Value – Select the measure to compare against the primary value.

• Font Size – Set the font size of the secondary value.

• Format Type – Same as primary value.

• Currency Type – Same as primary value.

• Precision – Up to 5 decimal places.

Trend

• Show Trend – Enable to display trend direction (upward or downward) based on rules.

• Trend Color – Choose a color for the trend arrow/icon.

Rules

Rules define comparisons and formatting between the primary and secondary KPIs.

• Primary Operator – Select operator for primary value (e.g., ≥, ≤).

• Operation – Choose the operation type for applying the condition.

• Secondary Operator – Operator for secondary value.

• Primary Color – Assign color for the primary value if the condition is met.

• Secondary Color – Assign color for the secondary value.

• Trend Direction – Define direction (Upward, Downward).

• Trend Color – Choose trend icon color.

Options:

• ADD – Add new rule.

• REMOVE – Delete an existing rule.

Note: You can set multiple rules. For example:

• If Primary ≥ Secondary → Trend = Upward, Green.

• If Primary < Secondary → Trend = Downward, Red.

Best Practices

• Use simple, meaningful labels (e.g., Revenue vs. Target).

• Apply currency and precision formatting to align with business context.

• Use rules sparingly—focus on highlighting critical conditions (e.g., below target).

• Choose trend arrows and colors that align with business meaning (e.g., upward/green = good, downward/red = bad).

• Keep comparative tiles consistent in layout across dashboards.