SSRS Mobile Reports Gauges
By: Siddharth Mehta
Gauges are generally used to represent Key Performance Indicators (KPIs) on a report or dashboard. Mobile Report Publisher offers different types of gauges, which can be logically categorized in three groups. Our intention is to understand the use of key configuration details of these gauges. A detailed explanation of every property of every gauge is beyond the scope of this tutorial. We will cover each gauge in brief and touch upon important details.
In SQL Server Reporting Services (SSRS) Mobile Report Publisher, the simplest gauges in terms of complexity are related to numbers and deltas. Monitoring statistics is the most basic and standard requirement of any dashboard. There are different ways to represent statistics. We can show actual numbers or percentages, highlight background or foreground, display actual values or the delta (difference) compared to the target metrics or goals. Every KPI has thresholds associated with it to display colors. As you can see below, gauges also provide options to define thresholds and associated colors.
Numbers and Delta Gauges
The four different gauges associated with numbers and delta are - Number, Delta Number, Delta indicator, and Number with delta.
Radial and Linear Gauges
The next set of gauges are radial and linear (vertical) gauges. These gauges are - Half-donut gauge, Speedometer, Cylinder and Thermometer. The configuration settings are almost similar for all these gauges. The choice of any particular gauge depends on the type of data and the comfort of end-users with the visual.
Progress Bars, Linear and Bullet Graph Gauges
The final set of gauges are Progress bar, Linear gauge, and Bullet Graph. Bullet graph is often used in desktop based reports as well and is one of the most popular gauges to display KPIs. The grey bar shows the actual value, the black vertical bar represents goal, the color represents the thresholds and the vertical lines on the bar represent the scale.
Gauges take less space and provide analysis for a single metric from different angles like goal, target, status, etc. Considering reading more about gauges from here.
- Gauges and charts are generally represented side by side. Consider using a common dataset and create a small report that contains at least two charts and one gauge.