Thanks for your reply Abhay !!
As i have mentioned in my previous post, the number of incidents displays the count (and percentage) of Met and Missed. But it shows Assigned group wise. We cannot represent this report to customer, as customer would like to see the overall %age of Missed and Met against the total number of incident tickets Closed/Resolved.
So if we can create 2 more column as "Total Met" and "Total Missed". Then we can achieve the requirement.
Any suggestions ?
2 of 2 people found this helpful
I created a sample report with Number of Incidents, Open Incidents and Closed Incidents.
The Open Incidents is a calculated field with a formula as shown below in screen shot.
Pulled these fields into the report canvas and used Advance Function on them using "Percentage Against Column" with Number of Incidents.
This way you calculated for met and missed calculated fields and use the advance function.
If required you can add assigned groups which will show the counts and percentage by group as well.
Hope this helps.
Thank you for the suggestion. It worked. But i am still a little away from the requirement.
I got the Total count of Met and Total count of Missed. But i am unable to work out on the %age part. Hope you help me out on this.
Total closed incidents = 967
Total Met Count = 37
Now i need to take the % of Met against the Total ticket closed and similarly the % of Missed against the Total Ticket closed.
So my output in the report should be % Met = 37/967 * 100 = 3.82 or 4% (Round up value)
And for % Missed = 930/967 * 100 = 96.17 or 96% (Round up value)