Hi folks,
I’ve been doing a fair bit of searching but haven’t found anything yet, so I’m turning to this board in the hopes that someone with more expertise can point me in the right direction.
I’m trying to make a line chart showing the cumulative number of total problem tickets opened over time along with the cumulative number of total tickets closed over time. I have variables that perform a RunningSum of total tickets and a RunningSum of total closed tickets, but I run into a problem when I try to chart these next to each other. (edit - in the same chart, I mean)
Here’s what I get when I graph these side-by-side: 
When I use the Submit Date for the ticket as my Category axis, it shows the data accurately with regards to the Running Sum of total tickets, however the closed tickets are incremented in the month that the ticket was opened, rather than the month that it was closed. If I try to plot it with the Closed Date as my Category axis, the Running Sum of closed tickets is graphed accurately, but the overall sum of tickets doesn’t work, because many of the tickets that are still open don’t have a Closed date, of course.
What I would like to do is to graph these together to show the delta between open and closed tickets, month over month. One way I can think to do this would be to have a graph with two X axes, however I can’t seem to find a way to do this in Web Intelligence.
Is there any way to overlay the two charts, or is there a way that I can create a variable, or manipulate my data to make this work?
Thanks for your time.
darrylc (BOB member since 2014-10-08)