Determining Range Values and Creating Computed Columns

  To determine the gauge range values and create a computed column to construct the values:

1. In Interactive Reporting Studio, open a dashboard that contains the Graphic Gauges component.

2. Open the results or table that contains a fact column, and determine the value range for the gauge.

   The Gauge Samples frame contains a list of gauge controls and the range of supported values. For example, Label for Set of 5 means the gauge supports values from 1 to 5.

3. In the results or table, create a computed column to produce the range values by reading the fact column.

   For example, if the gauge contains five gradations, the computed column produces 1 to 5 as the range. The fact column criteria determines the value of each row. A gauge that measures the fact Performance, has a computed column with the formula:

   if (Performance < .990) { 1 }
   else if (Performance < .995) { 2 }
   else if (Performance < 1) { 3 }
   else if (Performance < 1.03) { 4 }
   else { 5 }

   In Figure 14, Gauge Table Example, the computed column, or value range column, is called Value. The results or table is called the Gauge table. Each row in the table is potentially a gauge. Gauges are labelled to differentiate between them. For example, the Region column is a label column that is used to distinguish each gauge.

   Figure 14. Gauge Table Example

   

   If the Gauge table contains multiple fact columns, create another computed column. Configure the value range column for a second collection of gauges.

   Tip:

   To use, for example three out of five gauge images, ensure that the computed column returns only those three values.

   Caution!

   The Graphic Gauges component uses "_._" as a separator. Therefore, the string cannot be used in table or column names. For example, Gauge_._Table or My_._Column are not permitted.