I would like to create a query based on the incident table. I would like it to show only incidents which have breached the SLA and incidents which are about to breah by showing 50% and 75% too.
Our SLAs are set at percentages and there is a change of colour to a circle when the incident reaches 50% 75% and 100% how do I get this to show in a query as a percent.
E.G on a dashboard view I want each team to be able to see the incidents they have open at the moment which are at 50%, 75% or 100%.
I have tried to set a query based on the escalation point but when you click on the incident from the webdesk view you only see the excalation point not the actual incident.
I have tired to set it based on the incident but I cant seem to pick up percentages on this query.
Any help would be appriciated.
Thank you in advance