/build/static/layout/Breadcrumb_cap_w.png

Omit Weekend days/time

I am working on a report for showing time to close a ticket but we are for the most part a M-F 8-5 company. Does anyone know what I can do to omit non-work days from a report.

EXAMPLE

A ticket is created on Friday and is worked on but doesn't get a final resolution until Monday afternoon. Granted the ticket was open Fri, Sat, Sun, and Mon but the work days it was open was only Fri and Mon so I only want to report on the work days a ticket was open.

Also where can the database schema (layout) be found for reference when creating custom reports.

0 Comments   [ + ] Show comments

Answers (6)

Posted by: GillySpy 13 years ago
7th Degree Black Belt
0
It would be very difficult to figure out if you should exclude weekends, then you'd have to calculate how many weekends to exclude. Also what if someone does extra work on the weekend? That could create a scenario where they close a ticket in negative time.

The way that I have handled this is by implementing a "timer" using a custom field. This timer doesn't run on after hours (or on weekends by example).

An example of a timer . It requires two rules minimum -- one to increment the counters on eligible tickets every 15 minutes. Another to establish the counter when the ticket is changed (created or modified).

I don't have any code handy at the moment on that.
Posted by: rspencer 13 years ago
Orange Belt
0
I don't quite understand what the use of your timers are for? Calculating ticket time for business hours?

The ultimate purpose I am working towards is trying to determine as close as I can a true value for the time to resolve a problem for our help desk. There are several inherent problems/variables that need to be considered though when calculating this.

1. How much stalled time is involved, for instance waiting on a customer to respond to a ticket or waiting on management to approve a ticket. Its not a good measurement of time of resolution to include if a customer/user sits on a ticket for three days with no response
2. Ticket time for non-business hours - again its not a good measure to determine avg time to resolution if you include 48 hours of time when neither the tech nor the user are at work to resolve the issue.
3. Account for tech's time working on a ticket - we use the work log entries for this

Its fun/frustrating trying to create a report to show a true avg time to resolve tickets by tech and support team having to take all of these variables into consideration.

Does anyone else out there report on this? If so, what do you do to determine your avg time to resolution/close
Posted by: GillySpy 13 years ago
7th Degree Black Belt
0
The timer adds time while the ticket meets your conditions. E.g. time that at ticket is in an opened state (waiting on ticket owner and not closed). Then you add up said time in a report.

It doesn't help on existing tickets. it only helps for future tickets.

Sounds like you are measuring hours not days so are you a 24 hour shop during the week? If not do you not also need to take into account the time gaps in evenings->mornings?
Posted by: rspencer 13 years ago
Orange Belt
0
It sounds like the timers might be a good way to go. Then I could report on time a ticket is in an open status, stalled status, etc.

I assume you use triggers for setting off the timers when status gets changed to x.

Just to clarify, are your counters set up in more of a real-time fashion or do they only change in 15 minute increment values? What I mean is if a ticket is in an opened status for 8 minutes does the timer reflect such or does it only change values in 15 minute increments?

Are the timers visible to the end user in the ticket or is it something that runs in the background?
Posted by: GillySpy 13 years ago
7th Degree Black Belt
0
You would have two rules for one timer. All tickets have a timer -- in a custom field (that could be hidden or not). A subset of that have an active timer (ie qualify for updates). One rule would update the timer as the tickets change -- i.e. operate on a single ticket at a time ad hoc. Another rule would run every 15 minutes on the hour.

When you run your report you either run it during a time when the timers are "off" -- (off really means that no tickets meet the criteria like on a weekend) OR you run it right after a 15 minute (on the hour) interval so your data is as accurate as possible.
Posted by: svierneisel 13 years ago
Blue Belt
0
I am new to the Dell Kace system and I am in the process of setting up my Service Desk Module. I am very intrested in this feature as well. Actually, I am very surprised that there is not a "Working Hours" setting for this module. That would make this much easier.

Would you be able to post a screen shot of what you are talking about with creating your timers?
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
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