How to create Dashboard report

[Research]

Spoiler

Hi 

I want to create Dashboard reports for below requirments can any help on this 
Appreciated 

Reports: 
1.Incident Resolution Fixed Cost
2.Resolved by Known Error
3.Create to Resolve Duration
4.Assigned to Duration
5.Incident State Duration
6.First Call Resolution
7.Assignment Group

Thanks

[Shivalika · Accepted solution]

Hello @Research , 

Fixed code for incidents resolution is it some field ? 

For 2nd - Resolved by known error - you can create it by adding condition on resolution code field as known error. 

For 3rd tk 6th - you can go for incident_metric table , it stores duration for all the state values. You can filter the 'value' field on incident metric table as per the values of state you want for which you want duration . 

For 7th - report by assignment group is simple as it is a direct field on the incident table - so you can report on that. 

Please mark helpful if you found it useful in anyway. 

LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

[Research]

Hi @Shivalika 
1. Fixed cost don't have field
above requirements which is available in metric table
Same thing I want to create as report and attach/share to dashboard 
Any Suggestions

[Shivalika]

Hello @Research 

So where is the blocker ? You could directly create a report on incident_metric table and apply whatever filters you want ...

Please mark my above answer as helpful if it helped you in anyway 🙂 

[larsenjoyce]

Creating a dashboard report requires selecting the right metrics, organizing data effectively, and using visual elements for better insights. It's also essential to customize reports based on user needs. If you're looking for inspiration on how to structure engaging and well-organized profiles, check out bio cricket lover for creative ideas. A well-designed dashboard enhances decision-making and data interpretation effortlessly.