Navigation:  Vision >

Reference lines

The Reference lines option is available for the "Column", "Bar", "Line", "Pareto" and "Area" charts. This option allows entering a line or range with the objective of identifying values or a specific interval in an axis of the OLAP analysis. On the reference lines screen, configure the following fields:

Reference line: Define if the reference line will be a fixed line, a range or a variable line:

▪Fixed: If this option is selected, enter the Label, the Value and the Color of the line to be displayed in the chart.

▪Range: If this option is selected, enter the Label, the Initial value, the End value and the Color of the range to be displayed in the chart.

▪Variable: If this option is selected, enter the Label, the Measurement, the Aggregation function and the Color of the range to be displayed in the chart. For Measurement, all the measurement fields in the analysis are available. For the Aggregation function, the functions that return the sum, maximum, minimum, average, count or distinct count of the values of the selected measurement are available.

If necessary, the system allows other reference lines to be applied. To add a new reference, click on the button located in the bottom left corner of the reference lines screen. Then, configure the fields according to your needs. To delete a reference that is no longer necessary, click on the button located next to each configuration.