I am trying to generate a line graph that shows the percentage of all tickets that are solved by the 1st line ticket group. I can get the number of tickets reported correctly however, when I try and calculate the percentage it just shows the percentages relating to the number of tickets closed by 1st line and not for all the tickets.
I think I could do this if I selected all the ticket groups but that's not what I want to do.
The query I have configured is for the metrics of Count (Solved Tickets). The columns are Ticket Group and Ticket Solved - Month, and the row is Ticket Solved - Year.
Can you give any suggestions for how to achieve this?
Please sign in to leave a comment.