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

[Brian Dailey1]

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.

-Brian