Before You Begin

This tutorial shows you how to create gauge visualizations in Oracle Analytics.

Background

In Oracle Analytics, you can create a semi-circular, circular, horizontal bar and vertical bar gauge visualization. A gauge visualization can illustrate progress, goals, and key performance indicators for a measure. You can also include a dimension and create calculations to use in your gauge visualization.

What Do You Need?

Create a Dataset

In this section, you create a dataset from the sample_order_lines2023 spreadsheet.

  1. Sign in to Oracle Analytics.
  2. On the Home page, click Create and select Dataset.
  3. In Create Dataset, click Drop data file here or click to browse, select the sample_order_lines2023.xlsx file, and then click Open.
  4. In Create Dataset Table from sample_order_lines2023.xlsx, click OK. Click Save Save icon.
  5. In Save Dataset As, enter sample_order_lines2023, and then click OK.


    Description of join_diagram.png follows
    Description of the illustration join_diagram.png

Create Gauges in a Workbook

In this section, you create a gauge visualization with the sample order line2023 dataset.

  1. Click Create Workbook. Close the Insight panel.
  2. In the Data Data pane icon pane, hold down the Ctrl key, click Profit, Quantity Ordered, and Product Category.
  3. Right-click, select Pick Visualization, and then select Gauge Gauge visualization icon.


    Oracle Analytics puts the Product Category data element in Trellis Rows, Quantity Ordered in Values (Gauge), and Profit in Values (Target) in the Grammar pane.

    Description of three_gauges.png follows
    Description of the illustration three_gauges.png
  4. In the Grammar pane, select Quantity Ordered in Values (Gauge) and drag it to Values (Target) to trade places with Profit.


    Description of three_gauges_new_order.png follows
    Description of the illustration three_gauges_new_order.png

Compare Two Measures

In this section, you create a gauge visualization with two measures.

  1. Click Visualizations Visualizations pane icon. In Visualizations, drag Gauge Gauge visualization icon to the canvas and release it above the three gauges visualization.
  2. Click Data Data pane icon.
  3. In the Data pane, select Sales and drag it to Values (Gauge) in the Grammar Grammar pane icon pane.
  4. In the Data pane, select Profit and drag it to Values (Target) in the Grammar pane.


    Description of profit_sales_gauge.png follows
    Description of the illustration profit_sales_gauge.png

Specify Gauge Visualization Properties

In this section, you modify the default gauge visualization properties. Your property changes apply to the selected visualization. If you implement property changes in a visualization that produced multiple gauges such as in the Quantity Ordered, Profit by Product Category visualization, the changes update every gauge in that visualization.

  1. With the Profit, Sales visualization selected, click Properties Properties icon.
  2. Under Gauge, click None in the Range Label row and select Start/End.
  3. In Properties, click Values Properties values icon .
  4. Under Profit in the Tickmark Color row, click the black Color format icon box.
  5. In Tickmark Color, click a contrasting color in the color scale. Select a color and click OK.


    This tutorial selects a goldenrod yellow Yellow square icon. You can enter the Hex code #f6d805 in the color picker field to match the tutorial.

  6. In Properties, click General General properties icon. Under Gauge in the Type row, click Semi-Circular and select Circular.


    Description of gauge_prop_changes.png follows
    Description of the illustration gauge_prop_changes.png

Use Two Measures and an Attribute for the Gauge Visualization

In this section, you create a gauge visualization using the horizontal bar type and update the gauges properties.

  1. In the Data pane, hold down the Ctrl key, click Customer Segment and Profit. Right-click, select Pick Visualization and select Gauge.


    Description of profit_custseg.png follows
    Description of the illustration profit_custseg.png
  2. Click Properties Properties icon.
  3. In Properties under Gauge, click Semi-Circular in the Type row and select Horizontal Bar.
  4. In the Range Labels row, click None and select Start/End.


    Description of horizontal_bar.png follows
    Description of the illustration horizontal_bar.png
  5. In the Data pane, select Sales and drag it to the Profit by Customer Segment visualization.
  6. In Properties, click Values Properties values icon .
  7. Under Sales in the Tickmark Color row, click the black Color format icon box.
  8. In Tickmark Color, click a contrasting color in the color scale. Select a color and click OK.

    9. This tutorial selects a red Red square icon. You can enter the Hex code #e60f38 in the color picker field to match the tutorial.

    Description of profit_sales_custseg.png follows
    Description of the illustration profit_sales_custseg.png

Learn More