Report: Incident count by Assignment Group and display date of oldest Incident for each Assignment Group
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-26-2021 08:30 AM
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-26-2021 11:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-26-2021 12:45 PM
Thanks, but unfortunately no.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-26-2021 01:19 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-17-2025 06:10 AM
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