SLA find out

[Anonymous]

Number	Requested Date	Severity	Resolved
179270	10/02/2015 16:00	5
179260	10/02/2015 14:38	2
179258	10/02/2015 14:17	5
179255	10/02/2015 13:49	5
179254	10/02/2015 13:45	5	10/02/2015 13:55
179241	10/02/2015 11:53	5
179235	10/02/2015 11:06	1	10/02/2015 11:08
179223	10/02/2015 09:25	3	10/02/2015 09:58
179222	10/02/2015 09:13	5
179219	10/02/2015 09:05	3	10/02/2015 09:12
179206	10/02/2015 04:37	5
179200	09/02/2015 17:01	4

From the above list I want to find those records which missed the SLA

We need to consider the below condition-

1.

Severity 1 should be resolved within 3 hours

Severity 2 should be resolved within 5 hours

Severity 3 should be resolved within 3 business days

Severity 4 should be resolved within 5 business days

Severity 5 - No SLA

2.

Business timing should start from 9AM and end - 17PM

3.

Sat sunday are off day

4.

Need to follow holiday-1st may , 25th Dec

5.

If SLA fails then records should mark in RED

6.

If resolved date is null then mark it todays date.

     Please help

[#2]

Well, I have taken two variables for start and end time. Can you please paste the example or qvw and exactly how it is violating that business timing?

Thanks,

Abhishek

[#3]

I assume you are using chart, where you don't need to change anything. Moreover, I am using .csv file as source. Are you using xls? An XL sheet has its own formatting structure, if you are using it as source.

Thanks!

[Anonymous]

I have attached one xls file.

Many thanks again.

[#5]

a quick question..I think all the dates in your xls is in MM/DD/YYYY format ( and not in DD/MM/YYYY format), please confirm??? Because in my script I took them as DD/MM/YYYY.

[Anonymous]

DD/MM/YYYY format.

[#7]

For Dates that are shown in numbers/decimals, please go to chart->dimension. Click on respective dimension and then at Edit button.

For Request date use: timestamp(num#(RequestDate))

For Resolve date use: if(Index(ResolveDate,'.')>0,Timestamp(Num#(ResolveDate)),ResolveDate)

Please note that all this is done in chart and not in the script.

Hope that helps..

Thanks!

[Anonymous]

Many thanks I will check and let you know.

[Anonymous]

The request date and resolve date is working fine.

Comepletiontimeindetails is not giving me the result.

Please help me on that.

[#10]

What is that in result that you expected from CompleteTimeInDetail?

[Anonymous]

Time differnece not showing

I want to display <>hour <>minutes