Render options for chart series

[paul5950]

Hi,

In a line chart, if I want the user to be able to select between displaying, for instance, either an annual rate or a quarterly rate, is that possible? The user would select this via the prompt page. Both rates are currently displayed as separate series on the chart.

[CognosPaul]

There are several ways of doing this, dependent on the database you have. Is your source a cube or a relational? Are the different rates separate measures, or are they different rows? Are there any structural changes on the graph that need to be made for the different rates?

One way would be to create a conditional block. Create the a value prompt with the static values of Annually, Quarterly, Both. Set the block variable to a string variable based on paramDisplayValue('AnnualOrQuarterly'), adding Annually, Quarterly, and Both. Put a different graph for each block created.

If the source is relational, and the annually/quarterly options are in a series, simply use a filter.

If the source is dimensional, you could use a prompt with a measure set.

[paul5950]

Thanks Paul.  The conditional block works great.