/build/static/layout/Breadcrumb_cap_w.png

Report - How To Calculate Working Hours Only?

I am working on a report to show total time consumed since a ticket was openned until its closing.

Is there a way to calculate this period on a select query or do I need to create some counter (custom fields) to sum the working hours?

My report is getting just the difference between created and closed (including all nonworking hours and holidays). But I need to consider only working hours.

I appreciate any comment about this.


0 Comments   [ + ] Show comments

Answers (4)

Posted by: Hobbsy 4 years ago
Red Belt
0

There is no way in the standard configuration to get these kinds of stats from a Servicedesk queue. The SLA clock, for what it is worth, calculates a target due date by which time the SLA expires, rather than time that the ticket has been open in total.


If this is something you need, you will either need to dump out ticket data and calculate in excel, or alternatively we do still have access to some old code that at least is able to add up time between logging and closure. If that is something you need, then please get in touch.


Comments:
  • Thanks Hobbsy, could you shared this code with me? - asantana 4 years ago
    • Email me and i will send it over - Hobbsy 4 years ago
Posted by: Andrew.Simpson@stjohn.org.nz 2 years ago
White Belt
0
Hi Hobbsy, this is also something I am looking to do, i.e. calculate the collective 'Open' state time where the clock is not 'Stalled', is the Code you have above still valid and available please?
Posted by: Andrew.Simpson@stjohn.org.nz 2 years ago
White Belt
0
Hi Hobbsy, this is also something I am looking to do, i.e. calculate the collective 'Open' state time where the clock is not 'Stalled', is the Code you have above still valid and available please?
Posted by: Andrew.Simpson@stjohn.org.nz 2 years ago
White Belt
0
Hi Hobbsy, this is also something I am looking to do, i.e. calculate the collective 'Open' state time where the clock is not 'Stalled', is the Code you have above still valid and available please?
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ