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 ,

 your requirement is not possible, as platform analytics show realtime data - not historical data. To achieve your requirement performance analytics is needed.

[Nomaan Memon]

Thanks Anders.. Any tips on how this can be achieved with Performance Analytics?

[AndersBGS]

Hi @Nomaan Memon ,

 yeah, quite normal use case for performance analytics, as performance analytics takes snapshot of your data en preferred interval e.g. daily, weekly or monthly. 

[jeffrubinoff]

First, your license has to include it. A ServiceNow system admin in your company should know.

Second, if you do have it, you need people with training, starting with https://learning.servicenow.com/lxp/en/now-platform/performance-analytics-pa-essentials?course_id=a7.... It is quite complicated and you probably shouldn't pick it up for one use case.