Gauges are simple charts that indicate progress towards meeting a target. A Progress Bar gauge is similar to a thermometer that "fills in" to show how close the current value is to the goal. This gauge type does not include ranges. This gauge type is similar to a Filled gauge, which also "fills in" to show the proximity of the current value to the target—the difference is that a Progress Bar gauge shows the value as a percentage, whereas a Filled gauge shows the actual value.
Powering Progress Bar gauges
A Progress Bar gauge requires three columns or rows of data from your DataSet—one contains the current value of the gauge, one contains the maximum value, and the other contains the label that appears above the gauge. If multiple rows are present, only the data from the first row is used; all the others are ignored. If the first category contains more than one series, the series are aggregated to yield a single value for the gauge. Be aware that this aggregates the values for the maximum value column as well. For example, if your spreadsheet included two rows for "Team A" that both had a maximum value of 100, these would be aggregated in your chart to yield a new maximum value of 200. Selecting No Aggregation for either the current value or maximum does not currently work.
For information about value, category, and series data, see Understanding Chart Data.
In the Analyzer, you choose the columns containing the data for your Progress Bar 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.
The following graphic shows you how the data from the category and value columns in a typical column-based spreadsheet is converted into a Progress Bar gauge: