COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: cogman on 02 Apr 2008 11:42:42 AM

Title: Target Line in a line chart
Post by: cogman on 02 Apr 2008 11:42:42 AM
Hi

I want to draw a target line in a line chart. I have two series and i want to know when each series reached its target value.Please let me know if you are aware of any solution.

Thanks
CM
Title: Re: Target Line in a line chart
Post by: jguevin on 02 Apr 2008 12:46:04 PM
In the properties of the line chart under the Annotations section, there are baselines and/or markers you can add to your chart.  Hope this helps.  Jeff
Title: Re: Target Line in a line chart
Post by: cogman on 03 Apr 2008 12:08:22 PM
It will not help.any other ideas.
Title: Re: Target Line in a line chart
Post by: almeids on 03 Apr 2008 03:15:38 PM
Add 2 more series with static measure values?
Title: Re: Target Line in a line chart
Post by: cogman on 03 Apr 2008 04:00:32 PM
the target value must be straight line on y-axis. so adding 2 series may not solve it.

Title: Re: Target Line in a line chart
Post by: rockytopmark on 03 Apr 2008 07:43:12 PM
COGMAN!!!!

Both these suggestions you have received WILL PROBABLY WORK!!!

Are you trying to implement them before your replies?!?!?

The static values suggestion from Almeids will ABSOLUTELY work, since the target value expression will be the same along the entire set of data, thus giving you a line that is straight as can be.
Title: Re: Target Line in a line chart
Post by: cogman on 10 Apr 2008 04:21:28 PM
Are you trying to implement them before your replies?!?!? i am not posting for fun.



almeids and jguevin,your suggestions may work in some cases but our users have very high target value than their base value and they don't want to change the x and y axis coordinates everytime.

anyway i explained them how chart works now they want a different chart.

Thanks for everyone who replied in the thread.