yelyah.nodrog Posted November 6, 2017 Posted November 6, 2017 I am trying to create a measure that can tell me the percentage of calls breached by teams monthly. I want to know the percentage of calls that have breached response OR resolve times, by team. as well as overall totals for the department. I also want to know the overall percentage of calls that have been resolved within the response OR resolve times by team. This measure it generating percentage but I am not 100% sure it is true? 1, can someone advise if this is the correct way to write this measure 2, can someone advised me of how to generate this again in a report so I can confirm the measure is correct? Thanks! Hayley.
Guest Posted November 7, 2017 Posted November 7, 2017 Hi @yelyah.nodrog I think the basis of this is correct - but it might just need some small amendments: 1) Value Column - Change this to the Request ID 2) Query Where Clause - Change to (h_status = 'status.resolved' OR h_status='status.closed') AND h_resolvedby_teamname = 'Service Desk' 3) Percentage Sub Query - Change to (h_withinresponse = 0 OR h_withinfix = 0) Check to see if this works....if so you can take a copy and simply change the team name for other areas. Kind Regards Bob
yelyah.nodrog Posted November 7, 2017 Author Posted November 7, 2017 that worked! your a star! thankyou!
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now