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!
Don't use the Measures, use the Series boxes to hold your values from the joined query.
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?
Figured it out, simple left join did the trick :)