Before You Begin

This tutorial shows you how to add data bars to tables and pivot visualizations in Oracle Analytics.

Background

You can add data bars to a measure column in a table or pivot visualization. The data bars provide a visual representation of the size of the value in each row. You can change data bars' color, transparency, orientation from left to right or right to left, and whether the values in the row are visible. With data bars in measure columns, you can see the outliers in the records.

What Do You Need?

Create a Dataset

In this section, you create a dataset using the sample_order_lines2023.xlsx file.

  1. Sign in to Oracle Analytics.
  2. On your home page, click Create and click 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 sample_order_lines2023_ds.png follows
    Description of the illustration sample_order_lines2023_ds.png

Create a Table

In this section, you create a table and add data bars to a measure column.

  1. Click Create Workbook.
  2. In the Data data pane icon pane, select Product Sub Category and drag it to the canvas.


    Description of prodsubcat_table.png follows
    Description of the illustration prodsubcat_table.png
  3. In the Data pane, select Sales and drag it to Rows in the Grammar pane under Product Sub Category.


    Description of prodsubcat_sales_table.png follows
    Description of the illustration prodsubcat_sales_table.png
  4. Click Properties Properties icon. In Properties, click Edge Labels Edge labels icon.
  5. Expand Sales. In the Chart row, click None and select Standard Bar.


    Description of sales_data_bars.png follows
    Description of the illustration sales_data_bars.png
  6. Click Left to Right in the Direction row and select Right to Left.
  7. In the Color row, click Auto and select Custom. Click the box Fill color box in the Fill Color row. Your instance might use a different default fill color.
  8. In Fill Color, click a color in the palette and click OK.


    This tutorial uses a light yellow, #eff0c2.

    Description of table_data_bars.png follows
    Description of the illustration table_data_bars.png

Create a Pivot

In this section, you change the table to a pivot visualization and add an attribute and two measures.

  1. In the Data pane, select Customer Segment and drag it to the table visualization, before the Product Sub Category column.
  2. In the Grammar pane, click Table Table visualization icon and select Pivot Pivot icon.


    Description of custseg_in_table.png follows
    Description of the illustration custseg_in_table.png
  3. In the Data pane, select Quantity Ordered and drag it to Values in the Grammar pane above Sales.


    Description of qntyord_pivot.png follows
    Description of the illustration qntyord_pivot.png
  4. Click Properties Properties icon. In Properties, click Edge Labels Edge labels icon.
  5. In Edge Labels, expand Quantity Ordered, click None in the Chart row, and then select Standard Bar.
  6. Click Grammar.
  7. In the Data pane, select Profit and drag it to Values in the Grammar pane under Sales.
  8. Click Properties Properties icon. In Properties, click Edge Labels Edge labels icon.
  9. In Edge Labels, expand Profit, click None in the Chart row, and then select Standard Bar.


    If a product sub category doesn't have a profit value, data bars point in the opposite direction for the positive value data bars.

    Description of profit_in_pivot.png follows
    Description of the illustration profit_in_pivot.png

Learn More