Unrelated X-axis values...

This may seem like an odd request, but I'm looking to compare the magnitude (counts) of different/unrelated things within my chart. 
 
When I say unrelated, I mean they are unrelated at the database level. For example, I want to compare the number of trouble tickets to the number of projects. So, my Y-axis will be a count value, but my X-axis will consist of only two static values - {"Number of Projects", "Number of Trouble Tickets"}. I know this is probably a bone-headed request but I'm a little rusty. How would I structure my series and my X-axis to accomplish this? 
 
Thanks for any and all help! 
 
Matt 
<a href='mailto:' title='E-mail Link' class='bbc_email'>mcampbell@bowlinesolutions.com</a>

Find more posts tagged with

Comments

Purist

...what I wound up doing was creating a query that was a union of the query that calculated the number of trouble tickets with the query that calculated the number projects.

In each query I created a computed column called "CountType" that would be set statically to be either "Number of Trouble Tickets" or "Number of Projects" (e.g., SELECT x, y, "Number of Trouble Tickets" As CountType...) depending upon the query.

I then set the X-axis grouping to be on "CountType" (which only had two possible values) and turned on grouping. Y-axis was set up to be "id" which both queries shared in common - this was purely for use as the count variable.

Matt