Add a Reference Line to a Visualization

Reference lines enable you to identify averages, medians, percentiles, and similar information in a visualization.

You can use measure, attribute, date, and derived date columns to create reference lines and bands.

Derived dates are columns with different levels of granularity such as Year, Quarter, Month, and Day. Oracle Analytics automatically generates derived date columns for any Date, Time, or Timestamp columns in datasets.

You can bind a parameter to a reference line value or a reference band range in a visualization when you want to use a parameter value to place the reference line or band on the visualization. See Bind a Parameter to a Reference Line or Band.

When you configure the reference line in the Analytics pane on the Properties pane in the Grammar Panel, you might for example, select the Type option to display a line or a band, use the Function option to change the default line to Average, Percentile, Top N, or use the Z Order option for date and date order columns to position the reference line in front or behind a visualization. If you select a non-date attribute column, for example City, you can choose a Value, for example Chicago, on which to display the reference line.

1. On the Home page, hover over a workbook, click Actions, then select Open.
2. In the Data panel, click Analytics .
3. Click Add Statistics, and select Reference Line.
4. Use Column to select a measure, date, or non-date attribute.
5. In the Analytics pane select properties to update.
6. Click Save.