If you go back to the first report and use Pivot table (set Row & Column to your choice), you can add another filter like Opened on last month. That would give you counts for each day Opened is same day as Resolved.
Good morning,
Depending on what version you have there are a couple ways to go about getting what you need. My first recommendation would be a custom chart.
You can see a version of what you are trying to do here:
Click on "reports" then "Custom charts" and then "incident backlog".
This is a default out of the box report that you can modify. Right now it shows from now back to the beginning of time, but you can change the scope.
Here is an example (1 year, so a slightly customized version of the OOB one above):
As you can see it shows how many tickets are opened, how many are closed, and then shows a backlog tracker.
Now, you should be warned that customizing these charts is not supported officially by ServiceNow. So you'll need to rely on the community or internal sources. But, I think this gives you more or less what you want, just change the date range down to 1 day (or 1 week, etc.).
Is this helpful?
