Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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