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

Help req in chart report

Started by Mpotla, 03 Jun 2009 01:00:37 PM

Previous topic - Next topic

Mpotla

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