COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Mpotla on 03 Jun 2009 01:00:37 PM

Title: Help req in chart report
Post by: Mpotla on 03 Jun 2009 01:00:37 PM
Hi,
I need help in a chart report.
It has date on x-axis and different measures (units in hours) on y-axis. If you look at the attached image, you can have a better understanding.....

the measures are:
Report Hours: measure1 plotted against date1 (as points)
Maximum Physical TSN: as a straight line from (measrure2,date2) to (measure2,date3)
Current TSN: single value (measure3,date3)  ....(as a point)
Projected Hours Today: signle value  (measure4,date4)  ....(as a point)

NOTE: here date1,date2,date3,date4 are differnet columns ...(I'm joining multiple queries with RS to get a final query with differnt date columns and measures).

I need to plot all these in a single graph in cogos 8.1.

PLease hlep,

Thanks in Advance,
Mohan Potla