In Oracle Analytics, you can use a gauge visualization to show how a measure or metric performs against a target, within a specified range, or in comparison to other measures.

You can create a gauge visualization with a measure, or you can create multiple gauges as part of a trellis to monitor multiple measures and dimensions. For example, you might want to see how the total value of a measure column like Sales compares to a target value. You could use a set of gauges to monitor the quantity of products ordered for different product categories.

You can update the gauge visualization properties to show the start and end of the measure's range and customize the formatting, as well as configure the indicator for a target value.

You can use additional measure columns or calculations as start and end values for a range or as a target value to compare your data against. For example, if you want to see how the sales for different shipping modes are performing, you might create a calculation to use as the target sales values for a set of gauges.

This tutorial shows you how to create and customize gauge visualizations. Tutorial

Add a gauge visualization to your workbook.

1. On the Home page, hover over a workbook, click Actions, then select Open.
2. In the Data pane, select a measure column, right-click, and then click Pick Visualization.
3. Click Gauge to add a gauge visualization to the canvas.
4. Click Save.

Add a target value to a gauge so you can see how a measure is performing against a goal.

1. On the Home page, hover over a workbook, click Actions, then select Open.
2. Click a gauge visualization to select it.
3. In the Data pane, drag an appropriate measure or calculation to Values (Target) in the Grammar pane.
   
   
   Description of the illustration gauge_add_target.png
   
   
4. Click Properties. In Properties, click Values and expand the measure or calculation to modify it.
   
   
   Description of the illustration gauge_target_properties.png
   
   
5. Click Value in the Target Label row and select an option.
6. Click Auto in the Target Label Font row and configure the font.
7. Click the color box in the Tickmark Color row and select a color.
8. Click Save.

Customize a gauge visualization by updating the properties.

1. On the Home page, hover over a workbook, click Actions, then select Open.
2. Click a gauge visualization to select it.
3. Click Properties. Expand the Gauge section in the General tab.
   
   
   Description of the illustration gauge_general_properties.png
   
   
4. Optional: Click Semi-Circular in the Type row and select Circular to change the gauge to a circular shape.
5. Click Auto in the Start row, select Custom, and enter a value.
6. Click Auto in the End row, select Custom, and enter a value.
7. Click None in the Range Labels row and select Start/End. The range values match the start and end values that are specified in the Start and End properties.
8. Click the Values tab and expand the data element that you want to configure.
   
   
   Description of the illustration gauge_values_properties.png
   
   
9. Click Save.

Create a visualization containing multiple gauges to monitor the performance of a measure for multiple dimensions.

1. On the Home page, hover over a workbook, click Actions, then select Open.
2. In the Visualizations pane, drag Gauge to your canvas.
3. In the Data pane, drag a measure column to Values (Gauge) in the Grammar pane.
4. In the Data pane, drag an attribute column to Trellis Columns or Trellis Rows in the Grammar pane, depending on the orientation you want.
   
   
   Description of the illustration gauge_set.png
   
   
5. Click Save.