Report for Backlog vs Inflow vs Resolved incidents

[JAY138]

Hi there,

Every start of the day(say at 00:00 EST), I would like to show the backlog count at that point, inflow and the resolved incidents count in a bar chart as shown below. (Please note that I have the filters for each 3 of them ie backlog, inflow, resolved count filters) Could you please advise the steps to do this. I tried with Performance analytics as well as Trend chart report but couldn't do exactly as below. Your help is highly appreciated.

[Thomas_Davis · Accepted solution]

Hello,

As long as all three have the same day for the Created On, you could use additional Datasets to accomplish this.  Here is a ServiceNow Doc that talks about it.

https://docs.servicenow.com/bundle/istanbul-performance-analytics-and-reporting/page/use/reporting/t...

Here is a Community Blog that has a recent Office Hours that talks through also.

https://community.servicenow.com/community?id=community_blog&sys_id=5a3e245edb750490feb1a851ca961980

[JAY138]

Thanks Thomas, that really helped.

I have one more question, I want to report the count of a filter every start of the day(for ex. the backlog count at start of every day). I should have today's date on x-axis and count on y-axis. Is there any way I can display the today's date on x-axis as shown below. Appreciate your help.

[Thomas_Davis]

How many days of data are you trying to see on the report?  Are you looking for everything that was created this month by day? Or something else?

[JAY138]

Trying to show 1 month data in the report.

I'm looking to show the count of total number of tickets which are in open state at the start of the day.

(My filter for open state is : Assignment group=XYZ and state is not resolved and state is not closed)