Specifying the range values that are displayed

You can specify the range of values that you want to display in a visualization.

About this task

You can specify the range of values and categorical data that is displayed in visualizations. Some of the options that are available depend on whether you choose to render the visualization on the IBM® Cognos® server or on the client. When the visualization is rendered on the Cognos server, more choices are available when the visualization is in a master-detail relationship.

To control the range of values that is displayed, the following choices are available to calculate the minimum and maximum values of the range.

  • All data

    With this choice, minimum and maximum values are calculated to span the values of the inserted measure.

    When the visualization is added to an active report, the values are calculated to span the values of all controls that are connected to the visualization.

    Note: In visualizations that are added to active reports, the aggregation method that is specified in the Rollup Method property also affects the range of values.
  • All detail data

    This choice is available only when the visualization is in a master-detail relationship and is rendered on the Cognos server. With this choice, the range of data that is displayed is the same in each detail visualization.

  • Filtered data

    This choice is available only when the visualization is rendered on the client. With this choice, minimum and maximum values are calculated from values that users select in Active Report controls that are connected to the visualization.

  • Specified values

    With this choice, you specify the minimum and maximum values that you want to display in the visualization.

    Note: The minimum and maximum values that are displayed in the visualization might differ from the values that you specify. For example, if you specify a range of 0 to 195, IBM Cognos BI might display a range of 0 to 200.

To specify the categorical data that is displayed, the following choices are available.

  • All data

    This choice is available only when the visualization is rendered on the client. With this choice, all categorical data that spans the values of all Active Report controls that are connected to the visualization is displayed.

  • Filtered data

    This choice is available only when the visualization is rendered on the client. With this choice, only the filtered data is shown in the legend and on axes.

The choice that you make for displaying categorical data can affect elements in the visualization, such as the legend and axes. For example, when all data is selected, all legend items are always shown in the visualization, and the color of each legend item stays the same in the visualization. When a category is inserted on an axis, space is reserved on the axis for all data. When filtered data is selected, the color of each legend item can change when users select different values in a control that is linked to the visualization. When a category is inserted on an axis, the axis shows only the values that are selected in the control.

Procedure

  1. To specify the categorical data that is displayed, follow these steps.
    1. In the visualization data container, select the category that you want.
    2. In the Properties pane, click the Category Range property and select the choice that you want.
  2. To specify the range of values that is displayed, follow these steps.
    1. In the visualization data container, click the data item in the Values section that represents the values in the visualization. For example, in a packed bubble visualization, click the data item that is inserted in the Size box.
    2. In the Properties pane, double-click the Value Range property.
    3. In the Range type box, click one of the available choices.
    4. If you clicked All data, Filtered data, or All detail data, and you want the range of values to include zero, select the Range includes zero check box.
    5. If you clicked Specified, type the minimum and maximum values of the range in the Minimum and Maximum boxes.