Adding a Target Band

A target band is a horizontal or vertical band drawn on the chart that generally denotes either an ideal range (e.g., goal zone) or representative range (e.g., span of maximum to minimum). The region within the target band, as well as the regions above and below, can be assigned independent colors.

 

To add a target band, follow the steps below:

1. Right-click the Chart, and select 'Properties' from the context menu. This opens the 'Chart Properties' dialog box.

2. Select the Advanced tab of the 'Properties' dialog box. In the 'Target Lines' panel, press the 'Add' button. This opens the 'Add Target' dialog box.

3. Select the Band tab.

4. In the 'Field' menu, select the chart measure to which you want to add the target band.

5. In the 'From Value' field, enter a numerical value at which to place the lower band range for the selected measure, or choose one of the following options to compute the lower band range from the data: 'Average', 'Minimum', 'Maximum', 'Median', 'Sum'. (For example, select 'Average' to place the lower band boundary at the average value of the selected measure.)

 

6. In the 'From Label' menu, select one of the following label options:

 

a. Select 'Enter a Value' to type a custom label for the lower band boundary.

b. Select '(Target Value)' to insert the numerical value of the lower band boundary as the label.

c. Select '(Target Formula)' to insert the name of the computation method ('Average', 'Minimum', etc.) as the lower band boundary label, if applicable.

d. Select '(Field Name)' to insert the field name of the selected measure as the lower band boundary label, e.g., “Sum(Total)”.

Note: The custom­ized label supersedes any previous selec­tion from the 'From Label' menu.

7. (Optional) To further customize the label, press the 'Edit' button next to the 'From Label' field. This opens a panel in which you can manually enter the label. Press the green 'Apply' button when you have finished entering the label.

 

If desired, you can add the target band value, target band formula, and field name into the label by inserting the corresponding codes ({0},{1},{2}) shown at the bottom of the panel. You can format the inserted values using the same syntax as Custom Tooltip. Some examples are shown below:

{1} = {0,number,$#,##0}   yeilds   “Average = $383,485”

{1} of monthly {2}        yeilds   “Average of monthly Sum(Total)”

8. (Optional) If you select one of the available target band computations ('Average', 'Minimum', etc.), enable the 'Entire Chart' option to compute the target band value based on measure data from the entire chart. Disable the 'Entire Chart' option to compute the target band value for each sub-chart based only on measure data from the same sub-chart.

The following illustration demonstrates the effect of the 'Entire Chart' setting. (In both cases, 'From Value' is set to 'Minimum' and 'To Value' is set to 'Maximum').

 

9. Repeat the previous steps to set the 'To Value' and 'To Label' properties, which specify the position and label of the upper band boundary.

10. Select a 'Line Style' and 'Line Color' in which to display the upper and lower target band boundaries.

11. (Optional) Press the 'Fill Band' button and select a background color to fill the band between the lower and upper boundaries. Select a 'Fill Above' color and 'Fill Below' color to fill the regions of the chart above and below the band boundaries, respectively.

 

12. Press 'OK' to close the dialog box.

By default, the target band appears on the chart even if its upper or lower range values are greater than the largest data point. This may sometimes cause the data points on the chart to be compressed into a small region of the plot area, which makes the chart difficult to read. To correct this, turn off the 'Keep Element in Plot' option in the 'Plot Properties' dialog box. See Editing Plot Properties for more information.

See Also

Adding a Target Line, to place a target line or representative line on the chart.

Adding a Statistical Measure, to display statistical measures on the chart.

Adding Property Script (Expressions), in Dashboard Scripting, to set target line values and labels through expressions.

Dynamic Properties, set target line values and labels through Input Components.

<< Adding a Target Line © 1996-2013 InetSoft Technology Corporation (v11.5) Adding a Statistical Measure >>