Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Get number of incidents per assignment group assigned throughout a month & number of sla breaches

AdrianS
Tera Contributor

Hi!

 

Goal:

  • Monthly number
  • Have the number of incidents that have been and are currently assigned to each asgmt group
  • Have the number of sla breaches for those incidents for every asgmt group

 

Ask:

  • Is there a workaround or some method I can achieve this goal, aside from what I have tried.

 

Tried:

  • With performance analytics, I am using table, tableEx.
  • tableEx, contains the following information that will help me get this info. From what I have seen.
    • reference to Incident
    • Start and end dates that give the duration an incident was is assigned to a group
    • Value, String type, contains the assignment group name.
  • I am using and indicator source/indicator to get this information
  • I created a bucket breakdown source
  • With a scripted breakdown mapping, that returns an integer associated to every assignment group.
    • AdrianS_1-1727304143841.png
  • The problem with that I am receiving the following error, when I run the indicator's job
    • AdrianS_0-1727304046777.png

 

Request:

  • Is there a solution to my error?
  • Or
  • Is there a different way I can acheive my goal?

 

THANK YOU!

0 REPLIES 0