I have made a little progress but not sure that's what you wanted to display the report, I have added the MonthC org ref code using "Last Resolved Date" for Closed tickets, Month is used for Submitted and Open Tickets, But I am not able to use the Overlay Combination Chart to display as you have shown because of the measures. I hope experts can chime in and help here or give BMC Support a Buzz.

I am not an expert but learning from community as well.

There are two ways to get the report. Using the Submit date for created, open and closed and second is to use submit date for created and open and use Last resolved date for closed in same month. using submit Date makes it little easier but closed using last resolved date will add one more union.

Final Report ( Using Last Resolved Date for Closed):

Step1:

Calculated formula for create tickets.

Step 2: Add Union for Open Tickets

Map the fields see next screen shot. create calculated field open tkts and use for sub query filter to only show open tickets.

This post was extremely helpful as I am trying to create a similar report. However, even after following the steps in the word doc I am unable to accurate results for my resolved data.

The only difference is that I am creating my calculated fields off Submit Date & Last Resolved date. Basically I want to see how many tickets were submitted compare to resolved in the same month for 2017. Below are some screen shots... is it possible to create this report? If so, what am I doing wrong? I have confirmed that the data for Submit Date is correct, but my resolved data is inaccurate still.

For the operator option I have tried Equals, Equals Date Component & Same Operator, none of those options are giving me accurate results.

Thank you for the quick response, however, this is not exactly what I am looking for...

The Submitted calculation is only giving me those tickets that were Submitted in that month and are still open. I want to create a report that will look at ALL tickets (regardless of status) that were Submitted vs. how many were Resolved for the same month.

When I create 2 separate reports (First Report: Submitted; 2nd Report: Resolved). These are the numbers that I am expecting to see. So basically I just want an overview for each month in 2017 where I can see ALL the tickets Submitted vs. Resolved (regardless of existing status). is this even possible?