COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: leoraj on 26 Mar 2009 11:02:52 AM

Title: Insert a static line in charts
Post by: leoraj on 26 Mar 2009 11:02:52 AM
Hi,

Can any one tell me how to insert a static line for Average in the charts. I have a measure(eg: sales) that is shown as bars for each product, how to insert a line that shows average/target sales on that chart, to compare how the current sales are doing, if they are above the line or below the line.

Thanks,
Raj
Title: Re: Insert a static line in charts
Post by: rockytopmark on 26 Mar 2009 03:14:29 PM
That would be a second series.  There is also a Baseline attribute to charts, but it will generate a separate query.
Title: Re: Insert a static line in charts
Post by: leoraj on 30 Mar 2009 07:59:07 PM
Thanks. The baseline attribute worked.