Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
It will be really helpful if anyone of you can help me. I am struggling to get it done from days.
1. I need to find working hours taken taking 8 hrs a day
2. Add new column having value Success and Breach on Severity field as mentioned below :
Created | Resolved | Custom field (Severity) | Interval (Timestamp#(Resolved,'DD/MMM/YY hh:mm tt') - Timestamp#(Created,'DD/MMM/YY hh:mm tt'), 'h') | TIME RANGE | |||||
12/Mar/18 3:22 PM | 12/Mar/18 3:40 PM | S1-Critical | 0 | 1 | S1-Critical | 1 HR | SUCCESS | ||
12/Apr/18 2:19 PM | 12/Apr/18 2:36 PM | S3-Moderate | 0 | 2 | S2-Serious | 4HR | SUCCESS | ||
11/May/18 11:19 AM | 11/May/18 11:36 AM | S3-Moderate | 0 | 3 | S3-Moderate | 16 HR | SUCCESS | ||
18/Apr/18 4:26 PM | 18/Apr/18 4:41 PM | S4-Tolerable | 0 | 4 | S4-Tolerable | 16 HR | SUCCESS | ||
13/Mar/18 12:32 PM | 13/Mar/18 12:46 PM | S1-Critical | 0 | 5 | BLANK | BLANK | BREACH | ||
25/Apr/18 9:34 AM | 25/Apr/18 9:45 AM | S3-Moderate | 0 | 6 | >16 HR | BREACH | |||
28/Mar/18 4:45 PM | 28/Mar/18 8:13 PM | S3-Moderate | 3 | **WORKING HOURS MEANS 9-5 PM 8 HRS A DAY | |||||
Ye haath muje dede thakurr...haha..just kidding..
Can you please explain a bit in detail?
1. I need to find working hours taken taking 8 hrs a day - So you want to populate 8hrs for each row in a seperate column?
2. Add new column having value Success and Breach on Severity field as mentioned below : - need more clarity on this? please elaborate.
Hi,
1 -But how proceed if you get more than 8 hours a day or if you have less then 8 hours but out range (9-5pm)?
2- How works that definition of Success and Breach?
if([Custom field] = 'S1-Critical' AND Interval (Timestamp#(Resolved,'DD/MMM/YY hh:mm tt') - Timestamp#(Created,'DD/MMM/YY hh:mm tt'), 'h')<1, 'SUCESS',if([Custom field] = 'S2-Serious' AND Interval (Timestamp#(Resolved,'DD/MMM/YY hh:mm tt') - Timestamp#(Created,'DD/MMM/YY hh:mm tt'), 'h')<4, 'SUCESS', and so on..
you can use Match and pick for that as well