Report with bar chart to show all open records by the end of each month

[LK11]

Hi all,

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.

Thank you

[Srinivas Balusu]

Would you like to show the incidents which are currently in open state from last 1-6 months?

[darius_koohmare]

Adding a filter for 'opened' 'at or after' 'last 6 months' should achieve something similar to this

[LK11]

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

Thank you

[Goran WitchDoc]

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.