

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
help with a SLA calculation
Please help me with the formula in this qvw attached.
The objective is calculate the time between the initial and end date, considering only the time between 08:00 and 18:00 hs and ignoring saturdays and sundays.
See that lines 1 and 2 are wrong cause the initial date or the end date is in a not a network day. Line one should be 01:00 hour and line 2 should be 01:00 hour too.
The other lines are correct
Anyone has an idea how to fix that please?
- Tags:
- calculation
- sla
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
See attached qvw. I added some fields only so I could simply copy+paste swuehl's expression as is.
talk is cheap, supply exceeds demand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
See this discussion: Re: Working hours only
talk is cheap, supply exceeds demand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
See attached.
I didn't use your SLA calculation, although kept it in the script. Added a little more script to calculate "legal" Start and End time.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, Thank You very much, but almost there. If you put 10/01/2014 18:30:00 as start time and 13/01/2014 08:40 as end time, the SLA that should be 40 minutes but appears as 10 minutes.
Can you help me again? The qvw with this new date is attached.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
See attached qvw. I added some fields only so I could simply copy+paste swuehl's expression as is.
talk is cheap, supply exceeds demand


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank You Very Much for helping me!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Although it's resolved, I wanted to find out and to fix the problem. My previous solution didn't take into account initial time after 18 and end time before 8. Fixed in the new attached.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi all
I need some help and I am unable to start a new thread therefore I am using this as my issue is linked with an SLA calculation problem.
I would like to calculate the SLA of all incidents that have not been modified in the last 3 days.
SLA metric: >90%
Fields: Last Modified, Reference number
Anyone can advise with an expression to calculate it in chart and show as percentage?
Thank you in advance.
Kind regards
N.
