Bar Chart in Cognos

[cognosehelp01]

Hey guys,

I'm having an issue that may be easy to solve I'm just not getting it yet...

Basically I have two tables,
one holding parentIncidentID, pre-check outOfServiceType, pre-check outOfService count
the other holding parentIncidentID, pre-check outOfServiceType, post-check outOfService count

I want a chart that compares the outOfServiceTypes before and after a check but charts only allow me to use one data query.

I tried joining the tables on the parentIncidentIDand base chart off of that.

I get pre/post check serviceTypes as the Categories but then I am only allowed to put one (either pre/post outOfService count) as the measure, how do I go about placing both as measures or combining them??

Thanks!

[bdbits]

Don't use the Measures, use the Series boxes to hold your values from the joined query.

[cognosehelp01]

Awesome that helped, I put both in Series and now they appear side by side!

One more thing, if you could help please, I have them joined on the parentIncidentID and the pre-check outOfService = post-check outOfService...

I was wondering if it would be possible to also include the post-check outOfService events that did not occure in the preCheck?

[cognosehelp01]

Figured it out, simple left join did the trick :)