I am new to the system and not sure how to create certain queries to create a dashboard for the following;
1) I need a count of open Incidents this week and a Count of closed Incidents this week Which exit as seperate queries already so this is fine and I have added to a dashboard. But I need to show the variance between open and closed in the Dashboard also.
2) I also need to show the percentage of Incidents that breached the initial response SLA this week, pie chart would be ideal
3) Same as 2 but for the percentage of Incidents breached the overall SLA this week
I need a idiots guide, I can create basic queries and add them to the dashboard but that is about it.
Any asistance is greatly appreciated.