Jump to content

Breached call percentage by team


yelyah.nodrog
 Share

Recommended Posts

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?

Capture.thumb.PNG.8cfac57b8c7388f1da9fbe62a5f2ec4f.PNG

Thanks!

Hayley.

 

 

 

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...