If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Conditional Style applied to a Line Chart

Started by RS, 14 Oct 2008 05:24:20 AM

Previous topic - Next topic

RS

Hello all

I would appreciate if anyone expert could help me out on this.

I have a line chart and I would like to apply a conditional style to the line of series 1.
Something like this:



The X axis is a date/time axis. What I want is, by defining a threshold date, all the values after that date would be represented with another color. If the threshold could be a report parameter it would be even better.

I've tried to apply a condition style to the Y-axis default value (instead of using series) with a range date/time but it doesn't work  :(

Is it possible to do this in report studio?

Thank you in advance  :)

RS

Anyone could help please? I've read the report studio manual but that didn't help.
Conditional Palette doesn't work for line chart.
I just want to know it this is possible to do in report studio.

Thank you

zammi

#2
As per my knowledge only available solution is to use 2 series lines with calculated data items.

Example:
case
when [Fiscal Year] > 2005 then [Metrics].[Metric History].[Actual]
else null
end

This is because conditional palette doesn't support line chart (It works for bar graph).