JonathanD Posted April 18, 2017 Share Posted April 18, 2017 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 Link to comment Share on other sites More sharing options...
Guest Posted April 19, 2017 Share Posted April 19, 2017 @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. Link to comment Share on other sites More sharing options...
Guest Posted April 19, 2017 Share Posted April 19, 2017 @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 Link to comment Share on other sites More sharing options...
JonathanD Posted May 3, 2017 Author Share Posted May 3, 2017 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 ! Link to comment Share on other sites More sharing options...
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