Jump to content

Creating an Average Time to resolve measure


JonathanD

Recommended Posts

Hi Guys - My first time creating a measure and I'm struggling a bit - I did see this measure already pre-configured in a video describing reporting on the Hornbill Test instance so if someone can just cut and paste the correct config that would be handy.. 

In essence, I would like to be able to report on the average time taken to close our Critical and High tickets on a daily/weekly/monthly basis...

Thanks,

Jonathan

2017-04-18 (2).png

Link to comment
Share on other sites

@JonathanD I created a simple measure, you can try this one and then expand on it to add the query you want. Our measures are very similar except I added saved data columns which you don't need at this stage. And my Date Ranging Column is date logged as opposed to date closed but that shouldn't matter. My maximum sample history is only 12 and my thresholds are lower than yours. 

 

 

Resolve time average Measure.JPG

Link to comment
Share on other sites

  • 2 weeks later...

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
×
×
  • Create New...