Page History

...

Visual Analytics offers a set of reference values based on the underlying data of the user. It indicates values that are average, median, minimum, maximum, sum, or a user-defined constant. You can add a reference line on any axis of a measure or continuous dimension.

 
 
To add reference lines

1. Connect to the sample data source in Aqua Data Studio.
2. Build a Bar Chart.
3. Right-click on the axis, and then click Add Reference Line, Band, or Box.
   
4. In the Add Reference Line, Band, or Box dialog box, select Lines.

5. Choose a scope for the reference lines.

   Add Entire Table	Add Per Pane	Add Per Cell
   Visual Analytics calculates reference lines based on values in the table.	Visual Analytics calculates reference lines based on values in each pane.	Visual Analytics calculates reference lines based on values within each cell.

6. Specify a continuous dimension or measure from the current view as the basis for your reference line. From the adjacent list, select one of the following aggregate functions.
   
   • Sum adds all values in the view and places a reference line of the summed up values in the selected scope.
   • Total places a reference line based on the view's underlying data. It inherits the aggregate calculation from its field. For example, if placed on SUM(Quantity Ordered), Total will calculate the sum of the underlying Quantity Ordered data in the selected scope. If AVG(Quantity Ordered) is used, this results in a weighted rather than simple average of Quantity Ordered. The values obtained via this aggregate function match the result of the Show Row Grand Totals option from the Analysis menu. 
   • Constant places a reference line at the value that you specify in the selected scope.
   • Minimum places a reference line at the minimum value in the selected scope.
   • Maximum places a reference line at the maximum value in the selected scope.
   • Average places a reference line at the average value in the selected scope.
   • Median places a reference line at the median value in the selected scope.

   • Percentile place a reference line at the specified percentile value in the selected scope. Percentile value indicates the percentage of data points less than a given value. For example, if you place a reference at the 75th percentile, 75% of the data lie below that line. 

     Info

     All aggregate calculations (except Total) are based on the data in the view as opposed to the underlying data, which means, the calculation is being performed on the chart's visible data points. For these calculations, the view data is binned according to the scope and then the aggregate function is applied. If the user has defined a field calculation, this calculation will be carried out prior to the reference aggregation function. It is treated exactly as view data. Total is not available for calculated functions whose aggregation is AGG().

7. Choose how to label your reference lines from the following options.
   • None does not display any label for the reference line.
   • Value displays an aggregated value for the reference line.
   • Name displays a field name in use for the reference line.
   • Function Name displays an aggregation function name for the reference line.
   • Name-Function displays a field name and applied aggregation.
   • Custom allows creating a custom label. 
8. Choose formatting options for label alignment, line style, thickness, and color. You can also choose to have colors above and below the reference lines.  
   
9. Specify whether to recalculate line based on data selection. For more information, see Recalculate Data with Recalculated Lines.
10. Click Apply and then OK.
    

...