Viewing an embedded Gauge chart with the Trend data

You must select a standard worksheet for which the Report Source = Embedded and the rv_chart_number = 7 (Gauge). If the rv_measure_format is defined and the trendmeasure is generated using a valid measure, the measure defined in trendmeasure is displayed as a 'Trend' and the associated measure is displayed as a Gauge chart.

Process and Conditions

To create Gauge charts with a Trend, the measures must be displayed in the Pivot table and not in the Slicers area:

  • More than one measure must be passed to the pivot to enable the display of the trend data.
  • If the Gauge chart and Trend must be displayed side by side, the measures must be passed to the rv_measure_passed parameter in the order these entities must be displayed, that is, Gauge Measure1, Trend Measure2, Gauge Measure3, and Trend Measure 4 and so on.

Conditions:

  • A trend is plotted for each Gauge measure that is displayed, if an associated trendmeasure is defined. However, if a gauge measure is defined as a trendmeasure, the trend is not displayed as a Gauge chart.
  • A trendmeasure must be defined to display a trend. Consequently, some gauges can be displayed with or without trend.
  • If measures are defined in the top dimension and rv_chart_rows = TRUE (or if measures are defined in the rows and rv_chart_rows=FALSE), measures which are defined as a trendmeasure are not displayed as a Gauge chart.

Display settings

  • Based on the sign or value specified for the measure, the trend is displayed as a colored arrow or the = sign.
  • If the sign of the trend measures is positive, the value of the trendmeasure is used displayed a trend:
    • Positive = Green (up arrow)
    • Negative = Red (down arrow)
    • Zero or null = Amber (=).
  • If the sign of the trend measures is negative, the value of the trendmeasure is used display a trend:
    • Positive = Red (up arrow)
    • Negative = Green (down arrow)
    • Zero or null = Amber (=).