Report: Incident count by Assignment Group and display date of oldest Incident for each Assignment Group

Sapper
Kilo Explorer

Hi,

I am trying to see if their is a way to either display the Assignment Group, Incident Count, and the date of the oldest incident from that count or just the Assignment Group and the date of the oldest incident.

Is that possible? Also don't have the ability to run any scripts.

 

In the Dashboard I do have it where I have a report as a bar, Configured w/ the Display data table (which I really don't want the bar part).

The 'Display data table' has the Assignment Group, Incident Count and Percentage of Count (which don't want that part either).

So from there either being able to add the oldest (create) incident, or do another Report that will just display the date of the oldest incident.

To clarify: "Oldest (create)" is not the actual date, but how many days have passed.

Thank You!

4 REPLIES 4

Tsura Andreeva
Mega Sage

It sounds like you are looking for aging report for incidents per assignment group?

I would suggest using the Column report and group it by Assignment Group with Trend Created on by Month. Here is a sample - hope I understood your question correct.find_real_file.png

Sapper
Kilo Explorer

Thanks, but unfortunately no.

find_real_file.png

 

So, something that has the Assignment Group, the Incident Count, remove the Percentage of Count and instead include how old (days) is the oldest Incident.

 

Assignment Group Incident Count Oldest date pass
A 50 10 days
B 20 132 days

IF can it be Assignment Group and Oldest date (days) of Incident that will work too.

 

Thanks

 I am not aware of anything out of the box, you might have to create a script to calculate the age of the active Incident in the Metric Table per assigned group. Take a look in the incident_metric table at the duration value, you might be able to use that value to find your oldest ticket, then create a view between the incident and the metric table to get what you need.

 

i want to  create a report on incidents that are no updates on their  their assignment group since last 15 days   based on only assignment group even though other feilds are updated i dont care if assignment group is not updated i need it filtered list how can we achieve it