Tickets updated on or before 30 days

sriihs
Tera Expert

Hi Experts,

I am trying to create a simple indicator that shows me the tickets with no updates since 30 days or more. The indicator seems to be returning the right value but the dates are a bit mis-matched. For example, in the below screenshot, you can see that the count is 1 from june. If you open the record, the incident was opened and last updated in the month of May. How do I ensure that this ticket is shown in the month of May instead of June? So, what I would like to display is that this ticket was created in the month of May and has no updates since.

Please advise.

find_real_file.png

find_real_file.png

1 ACCEPTED SOLUTION

Erik Hoffmann
ServiceNow Employee
ServiceNow Employee

Hi Sowmya,



that is not possible using PA as it takes snapshots, and at snapshot in May the system does not know it will be 30 days not updated when you reach June.



You can get to a chart that depicts what you want by using a report. Create a report of type 'time series' like 'column', set the trend by on 'created' field by month. And then in conditions make sure you only plot those incidents that are not updated more than 30 days.



Best regards,


Erik


View solution in original post

2 REPLIES 2

Erik Hoffmann
ServiceNow Employee
ServiceNow Employee

Hi Sowmya,



that is not possible using PA as it takes snapshots, and at snapshot in May the system does not know it will be 30 days not updated when you reach June.



You can get to a chart that depicts what you want by using a report. Create a report of type 'time series' like 'column', set the trend by on 'created' field by month. And then in conditions make sure you only plot those incidents that are not updated more than 30 days.



Best regards,


Erik


Thank you!