Reporting on backlog data 30 days ago (dynamic)

[Nomaan Memon]

We have a table called 'incident backlog' in our ServiceNow instance which collects all incidents unresolved as of 11:59 pm each night over the past couple of years. 
Using this table i want to create a report that shows incident records that were unresolved 30 days ago (i.e., unresolved at that past point in time), not necessarily still open now, and not in the last 30 days.
Eg: Today June 24 i have 200 unresolved Incidents, i want to find how many incidents were unresolved 30 days ago i.e. around May 24. Sort of a dynamic report. This would then show on June 25 how many unresolved incidents were there on May 25.

Any tips how this could be done using the native reporting platform or using Platform Analytics?

Thanks,

[AndersBGS]

Hi @Nomaan Memon 

do you have experience with performance analytics? If not I would recommend you to take the official training. As stated earlier, this us a quite normal use case.

[ThaiP · Accepted solution]

Hi @Nomaan Memon ,

I found a ServiceNow article from 2022 that might answer your question.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0823423