- My View
I'm new to ServiceNow and I need to produce a report to a group with bar chart to show all the open requests by the end of each month. The report should be for the last 6 months and it should be dynamic so that the report will show last 6 months open records as soon as the month changes.
Eg: March - Aug records will move to April - Sept once the month moves into Sept.
It would be great if someone could help me with this.
Would you like to show the incidents which are currently in open state from last 1-6 months?
Please hit Like / Helpful / Correct based on the impact of my response
Srini & Darius,
For each end of the month I need to show the number of open records and 'in progress' as well if possible. Not total number of open records for the last six months.
eg: March - no. of open records & 'in progress'
April - no. of open records & 'in progress' and so on...... for last six months
If you want to have a report that shows how many icident was open & in progress at the end of each month(last 6 months) you either need performance analytics or doing a metrics that counts and saves the value. Then you do your reports on the metric values.
This since in the OOB reporting( not Performance analytics) you can go back and for example see how many incident was open at the end of last month. But not multiple months in one report.
Example: Lets say you want to see which incident were open at the 31 of May.
To do this you need to set condition to be "Opened before 31 may 23:59:59" and "Closed after 31 may 23:59:59".
So it's doable OOB without metrics for one month, but for multiple you need to do some more work or buy PA to do the work for you.
ServiceNow Witch Doctor and MVP
For all my blog posts: http://bit.ly/2fCzj1g
To expound on Goran's idea without using PA, you can create a scheduled job that runs at the end of every month to query the records for everything opened that month and the total that are still active, and then write those values to a metric record. You will need to define your metric first, and your chart would simply point to this metric table with a condition limiting it to the past 6 months.