Adding Reference Bands

Reference bands are shaded areas behind the marks in the view between two constant or computed values on the axis. You can add reference bands to any continuous axis.
To add a reference band:
  1. Right-click on a quantitative axis and select Add Reference Line, Band, or Box.

  2. In the Add Reference Line, Band, or Box dialog box, select Band.

  3. Select one of the following scopes:

  4. Select two measures from the Value field—one in the Band From area and one in the Band To area—to use as the basis for your reference band. You can also select an existing parameter, or create a new parameter on the fly.
    You cannot select a measure that isn't currently in the view as the basis for your reference band. If this is what you want to use, close the Add Reference Line, Band, or Box dialog box and then drag the measure you want to use from the Data window to the Details target on the Marks card and change the aggregation if necessary. This will not change the view, but it will allow you to use that measure as the basis for your reference band. Now re-open the Add Reference Line, Band, or Box dialog box and resume at step 1, above.
    Select measures or parameters from the first drop-down menus and then select one of the following aggregations:
    • Average - places a line at the average value along the axis.
    • Constant- places a line at the specified value on the axis.
    • Maximum - places a line at the maximum value.
    • Median- places a line at the median value.
    • Minimum - places a line at the minimum value.
    • Sum - places a line at the SUM of all the values in either the cell, pane, or entire view.
    • Total - places a line at the aggregate of all the values in either the cell, pane, or the entire view. This option is particularly useful when computing weighted average rater than an average of averages. It is also useful when working with a calculation with a custom aggregation. The total is computed using the underlying data and behaves the same as selecting one of the totals options in the Analysis menu.

  5. Format the reference band. You can mark the two values with a line and select the color to shade between them with.

  6. When finished, click OK.

No comments:

Post a Comment