Visualizing performance relative to targets with KPIs and gauges
KPI and gauge visuals are frequently used to present the most performance in dashboards. Given their compact size and supporting context, such as trend graphs and target values, users can quickly obtain useful insights from these visuals alone, on any device. However, to derive the most value out of these visuals, it’s often necessary to apply Visual level filters, create supporting target measures, and group related visuals.
In this recipe, a KPI and gauge visual are developed to present growth relative to planned growth. Groups of KPI visuals are then created to provide visibility to current period, prior period, and year-to-date.
How to do it...
- Identify the measure:
- This measure will serve as the Indicator input for the KPI visual and the value input for the gauge visual
- Define the grain:
- For the KPI visual, the date dimension column used in the trend axis input will determine
- For example, a period trend axis will result in...