Gauges are simple charts that indicate progress towards meeting a target. Comparative Fill gauges are similar to Filled gauges but more complex. Whereas a Filled gauge shows you only the current value, a Comparative Fill gauge also shows the previous value. This allows viewers to see the degree of change since the gauge was last updated. In addition, the percentage and direction of change appears in the center of the chart. You can also specify an optional target value in a Comparative Fill gauge.
Comparative Fill gauges come in two types: basic and advanced. These are the same except that the advanced type includes additional parameters not available in the basic version. For example, you can create ranges and specify median values. These elements are displayed on a second circle in the gauge for a cleaner look.
Powering Comparative Fill gauges
A basic Comparative Fill gauge requires four columns or rows of data from your DataSet. These columns or rows are as follows:
One contains the minimum or lowest value that appears on the gauge.
One contains the maximum or highest value that appears on the gauge.
One contains the current value for the gauge.
One contains the previous value for the gauge.
An advanced Comparative Fill gauge requires all of the above columns, along with the following:
A column with a lower range value.
A column with an upper range value.
A column with a median value.
With both basic and advanced Comparative Fill gauges, you can also include an optional target value column.
The following screenshot points out all of these elements in an advanced Comparative Fill gauge, along with the percentage and direction of change (which is calculated automatically based on your previous and current values):
If multiple rows are present in your DataSet, only the first row is used. No aggregations occur.
In the Analyzer, you choose the columns containing the data for your Comparative Fill gauge. For more information about choosing data columns, see Applying DataSet Columns to Your Chart.
For more information about formatting charts in the Analyzer, see KPI Card Building Part 2: The Analyzer.
Customizing Comparative Fill gauges
You can customize the appearance of a Comparative Fill gauge by editing its Chart Properties. For information about all chart properties, see Chart Properties. For more information about gauge properties, see Setting Properties for Gauges.