We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

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