Jump to content
JonathanD

Creating an Average Time to resolve measure

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

Share this post


Link to post
Share on other sites
Guest

@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

Share this post


Link to post
Share on other sites
Guest

@JonathanD When I use this measure in a widget this is what I get. Is this anything similar to what you are looking for?

 

regards

Pamela

 

widget2.jpg

Share this post


Link to post
Share on other sites

Many thanks Pamela - I seem to have it working now at last ! I need to go back to the webinars for a bit I think ! ;) cheers !

Share this post


Link to post
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

×
×
  • Create New...