Create a Metrics Range Chart

This example has three parts: creating a metrics range chart, customizing it, and customizing the chart legend labels.

Procedure

  1. Open IBM® Cognos® Report Studio with the GO Data Warehouse (query) package.
  2. In the Welcome dialog box, click Create a new report or template.
  3. In the New dialog box, click Chart and click OK.
  4. In the Chart group pane, click Metrics Range.
  5. In the Chart type pane, click Column Chart with Range Indicators and click OK.
  6. From the Source tab source tab, expand Sales and Marketing (query), Sales (query), and Sales fact.
  7. Drag Revenue to the Actual (Y-axis) drop zone.
  8. Drag Planned Revenue to the Target (marker) drop zone.
  9. Expand Time dimension, and drag Quarter to the Categories (X-axis) drop zone.
  10. From the Toolbox tab toolbox tab, drag a query calculation to the Tolerance (marker) drop zone.
  11. In the Create Calculation dialog box, type Tolerance.
  12. In the Expression Definition box, type [Planned revenue] * 0.1 and click OK.
  13. Run the report and then pause the pointer over each bar to see the revenue for that quarter.
Parent topic: Example - Creating and Customizing a Metrics Range Legacy Chart