Jump to content
Joyce

Open Ticket age Widget

Recommended Posts

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

 

 

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

@Joyce you really like to give us a challenge :D .... 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...

Share this post


Link to post
Share on other sites

Yes I was thinking the same, using multi series with Sql .

Share this post


Link to post
Share on other sites

@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?


Vinci_Aged_Incidents.PNG

  • Like 1

Share this post


Link to post
Share on other sites

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. 

Share this post


Link to post
Share on other sites

@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

Share this post


Link to post
Share on other sites

@Prathmesh Patel one more thing... response or resolve SLA ? :) ... if you need both them might require separate measures/widgets/reports...

Share this post


Link to post
Share on other sites

@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 ?

 

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...