Joyce Posted May 10, 2017 Share Posted May 10, 2017 Hi, How can I calculate request age (how many days, the ticket has been open for) to date on the sql query in widget? Thanks. Regards, Joyce Link to comment Share on other sites More sharing options...
Victor Posted May 10, 2017 Share Posted May 10, 2017 @Joyce you need something like this? Link to comment Share on other sites More sharing options...
Joyce Posted May 10, 2017 Author Share Posted May 10, 2017 Yes, I need the number of days, then create a chart with 3 series, from 0-7 days, from 8-14 days, and from 14-21 days, on counter of Active request, within teams. What query have you use to get the number of days? Thanks. Regards, Joyce Link to comment Share on other sites More sharing options...
Joyce Posted May 10, 2017 Author Share Posted May 10, 2017 Looking for something like this Request by age-Hornbill.docx Link to comment Share on other sites More sharing options...
Victor Posted May 10, 2017 Share Posted May 10, 2017 @Joyce you really like to give us a challenge .... I'll have a look tomorrow morning... On top of my head it should (emphasise on "should) be doable using multiple measures and again, multi series... Link to comment Share on other sites More sharing options...
Joyce Posted May 11, 2017 Author Share Posted May 11, 2017 Yes I was thinking the same, using multi series with Sql . Link to comment Share on other sites More sharing options...
Victor Posted May 12, 2017 Share Posted May 12, 2017 @Joyce sorry for the delay. Took the liberty to create a test widget in your instance (Hornbill Test - Aged Incidents), hope this is all right... is this what you were looking for? 1 Link to comment Share on other sites More sharing options...
Joyce Posted May 12, 2017 Author Share Posted May 12, 2017 Fantastic @Victor, this is exactly what i need. Thanks Link to comment Share on other sites More sharing options...
Prathmesh Patel Posted May 15, 2017 Share Posted May 15, 2017 This is what i require too. but need in SLA and OUT of SLA 1 Link to comment Share on other sites More sharing options...
Victor Posted May 24, 2017 Share Posted May 24, 2017 @Prathmesh Patel did you manage to get the In/Out of SLA widget? Link to comment Share on other sites More sharing options...
Prathmesh Patel Posted May 24, 2017 Share Posted May 24, 2017 Victor, thanks for asking. i haven't to be honest. I doing it manually at the moment. What do i need to insert into the widget to get the data out. Link to comment Share on other sites More sharing options...
Victor Posted May 24, 2017 Share Posted May 24, 2017 @Prathmesh Patel how do you define In/Out of SLA... is it on all active requests (open, on-hold, resolved) or just resolved? or just closed? I think is faster if I create a test widget for this in your instance and walk you through it after if you have any questions on it...let me know if is all right with you Link to comment Share on other sites More sharing options...
Prathmesh Patel Posted May 24, 2017 Share Posted May 24, 2017 Victor, Thanks, Yes, all active request. Link to comment Share on other sites More sharing options...
Victor Posted May 24, 2017 Share Posted May 24, 2017 @Prathmesh Patel one more thing... response or resolve SLA ? ... if you need both them might require separate measures/widgets/reports... Link to comment Share on other sites More sharing options...
Prathmesh Patel Posted May 25, 2017 Share Posted May 25, 2017 Open tickets Link to comment Share on other sites More sharing options...
Victor Posted May 25, 2017 Share Posted May 25, 2017 @Prathmesh Patel I understand is open tickets, my second question was if you need a In/Out SLA report for Response or Resolve? Or both? 16 hours ago, Victor said: @Prathmesh Patel one more thing... response or resolve SLA ? Link to comment Share on other sites More sharing options...
Prathmesh Patel Posted May 25, 2017 Share Posted May 25, 2017 apologies, resolve please Link to comment Share on other sites More sharing options...
Ben Maddams Posted November 16, 2021 Share Posted November 16, 2021 @Victor Hi Victor, I've been trying to recreate the widget you've added a screenshot of in this post, is there any chance of getting the SQL behind this as it would be incredibly useful? Link to comment Share on other sites More sharing options...
Victor Posted November 16, 2021 Share Posted November 16, 2021 @Ben Maddams umm... I probably need to build it again, assuming is still possible in current functionality... it's been... erm, quite a while since this thread... Link to comment Share on other sites More sharing options...
Ben Maddams Posted November 16, 2021 Share Posted November 16, 2021 @Victor Aye I just noticed the date! Sorry about that. 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