Help with filters

carolinesantana
Kilo Contributor

Dear,

I have a question about the "service-now.com" platform. Is it possible to filter all tickets that were assigned to an "Assignment Group" on a specific date? What I want is not the date of creation or last update of the ticket, but if the "Assignment Group" field was changed on the specific date.

1 ACCEPTED SOLUTION

bammar
Kilo Sage

Hello,

 I beleive you would have to use performance analytics for that. It takes a snapshot daily for how many incidents a group had on that given day.   But even then that wouldnt answer your question because some of those incidents may not have been assigned that day. So Unless there is a Out of Box field - you would create a date field yourself called - Last Assigned Date - and a Business rule would write to it with the time every time the assignment group value changed. Then you could have reports that show things like  - Incidents in assignment group X assigned today . and all sorts of other things. It could be useful especially since updated is the last update and it isnt necessarily the assignment group field...

View solution in original post

1 REPLY 1

bammar
Kilo Sage

Hello,

 I beleive you would have to use performance analytics for that. It takes a snapshot daily for how many incidents a group had on that given day.   But even then that wouldnt answer your question because some of those incidents may not have been assigned that day. So Unless there is a Out of Box field - you would create a date field yourself called - Last Assigned Date - and a Business rule would write to it with the time every time the assignment group value changed. Then you could have reports that show things like  - Incidents in assignment group X assigned today . and all sorts of other things. It could be useful especially since updated is the last update and it isnt necessarily the assignment group field...