column chart for closed tickets
We are planning to design a column chart for closed tickets. We have 3 types of severity (High, medium and low) . We are getting values for closed tickets, but we are not getting SLA (in percentages) from backend data source. How to calculate it.
-
Hi Akondi,
I guess you need the number of opened tickets, then you can add a formula like COUNT(Closed Tickets) / COUNT(Opened Tickets). Depending on our data structure, you can then add filters/split by severity in various ways to calculate different KPIs. I would rather import that kind of datas. If you import directly SLAs you will have less flexibility for working on different KPIs and let your users slice the data.
Best, David.
Please sign in to leave a comment.
Comments
3 comments