To be honest I am not even sure where to start. I have three measurements I need to add to a report. Each one is a date difference that also include start and stop times and no weekends. Any help would be appreciated.
Measure One
PPM - M/F 07:00 to 19:00 (SNOW)
Case open date must fall between PPM or start clock for next day
Case must be assigned to Clarify if open within the PPM - Clarify Created date
Measure Two - Part Order
The part order must take place within the case open PPM
Case open date - SNOW = Case open date - Clarify
Part order date - Clarify
Measure Three - Part Ship
The PPM for the part order is M/F 07:00 to 14:00
The part needs to be ordered within the Part Order PPM
If the Part order is within the Part Order PPM the part need to show as shipped on that date
Part order (Clarify) 03/23/2023 13:30 = Part Ship date (Clarify) 03/23/2023
If the part order was completed outside of the part order PPM than the part must show shipped the next day.
Part order (Clarify) 03/23/2023 14:30 = Part Ship date (Clarify) 03/24/2023
INC_TICKET_NUMBER | F_CASE_ID | INC_INCIDENT_STATE | CUST_ENT_CODE | INC_CREATED_DATE SNOW | F_CASE_CREATED_DT Clarify | Measure One | ORDER_DATE, Clarify | Measure Two | GOOD_PART_SHIP_DATE Clarify | Measure three |
INC42412071 | C220330-17140679 | Closed | AE WORKSTATION | 3/30/2022 14:22 | 3/30/2022 14:28 | Pass | 3/30/2022 14:38 | Pass | 3/30/2022 14:43 | Pass |
INC44398734 | C221024-17426468 | Closed | AE WORKSTATION | 10/24/2022 15:04 | 10/24/2022 15:17 | Pass | 10/24/2022 15:44 | Pass | 10/24/2022 16:08 | Pass |
INC44399012 | C221024-17426497 | Closed | AE WORKSTATION | 10/24/2022 15:23 | 10/24/2022 15:25 | Pass | 10/24/2022 16:03 | Pass | 10/25/2022 11:20 | Pass |
INC44398860 | C221024-17426481 | Closed | AE WORKSTATION | 10/24/2022 15:13 | 10/24/2022 15:21 | Pass | 10/24/2022 16:16 | Pass | 10/25/2022 11:23 | Pass |
