Page History
...
- Connect to the sample data source in Aqua Data Studio.
- Build a Bar Chart.
- Right-click on the axis, and then click Add Reference Line, Band, or Box.
- In the Add Reference Line, Band, or Box dialog box, select Band.
Choose a scope for the band.
Add Entire Table Add Per Pane Add Per Cell 
Visual Analytics calculates reference bands based on values in the table.
Visual Analytics calculates reference bands based on values in each pane. Visual Analytics calculates reference bands based on values within each cell. - Specify a value to use as the basis for your reference band. You can select a value that is part of your current view from the Band From and Band To areas. From the adjacent list, select one of the following aggregate functions.
- Sum adds all values in the view and extends a reference band of the summed up values in the selected scope.
- Total places a reference band 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 extends a reference band up to the user specified value, in the selected scope.
- Minimum extends a reference band up to the minimum value in the selected scope.
- Maximum extends a reference band up to the maximum value in the selected scope.
- Average extends a reference band up to the average value in the selected scope.
- Median extends a reference band up to 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.
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().
- Choose how to label the bands from the following options.
- None does not display any label for the reference band.
- Value displays an aggregated value for the reference band.
- Name displays a field name in use for the reference band.
- Function Name displays an aggregation function name for the reference band.
- Name-Function displays field name and applied aggregation.
- Custom allows creating a custom label.
- Configure the appearance of the band by selecting label alignment, style, thickness, and color for the lines and shaded area.
- Specify whether to recalculate line based on data selection. For more information, see Recalculate Data with Recalculated Lines.
- Click Apply and then OK.
...