Reference line

Reference lines are used in charts as a benchmark against which to compare data points. This helps viewers quickly assess whether values are above or below a certain target, goal, or historical average. They also help identify trends and aid in making comparisons between different segments.

You can add reference lines for the average, minimum, maximum, standard deviation, etc of a measure or the variance.

1.Position

The reference line can be horizontal or vertical. Click the images to see the different positions available for reference lines.

You can choose the position of the reference line on the x-axis when the vertical option is selected. In the example, the reference line is rendered at the fourth position.

2. Display

You can use measures or the absolute or relative variance to plot reference lines. Select the source from the dropdown.

3. Based on

Select the aggregation method to be used to plot the reference line. You can also plot a reference line based on a custom input value. Click on the images to view reference lines plotted using maximum, minimum, median, and standard deviation.

Leverage the "Field" option in analytics to use storytelling tools like data-driven reference lines. Plot reference lines using input measures to visualize data over time, detect trends, and identify potential concerns. To plot data-driven reference lines, choose "Field" from the Based on dropdown and select the measure from the Value dropdown.

4. Line

Set the style (solid, dotted, dashed), thickness, and color of the reference line.

5. Placement

The reference line can be rendered in front of the chart or behind the chart using this option. In the example, we've plotted the reference line behind the chart.

6. Label

Enable the label toggle to display the data values for reference lines.

• Type

Analytics+ displays the aggregation type and the value used to plot the reference line. You can choose from the options listed below:

• Text: displays the aggregation type only

• Value: displays the calculated value only

• Text + Value: displays the aggregation type as well as the calculated value

• Name: You can set a custom name for the reference line. By default, the selected aggregation type will be displayed. In the example, we've set the name of the reference line to "Avg of AC".

• Format: You can set the label font size, style, and color. You can choose from Regular, Semi bold, and Bold font styles.

• Background color: Highlight reference line values by setting a custom background color.

• Vertical: Set the vertical positioning of the label with respect to the reference line.

• Horizontal: Set the horizontal positioning of the label with respect to the reference line.

• Offset: You can position the label anywhere within the canvas by specifying the x and y coordinates.

• Rotation: The labels can be rotated for enhanced visibility.

Reference lines for time series data

When your dataset contains a time series, you can render reference lines for custom dates or the current date or n-days from the current date. Select the Timeseries radio button as the Type option.

When you choose the Days upto today or Days from today options, you can specify the number of days.