Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am getting the following issue after opening the load editor. This is happening after using match function and also after many if else conditions are used for the same parameter field (PResponseTime).
Can you please suggest if this error is because of the performance or something else is causing the same?
Regards,
Romila
Hi Andres,
Thanks for the reply but I do not think there is issue because of RAM memory. Please see below screenshot of my system for your reference.
In my code I am trying to calculate the response time for a ticket created based on the SLA and the priority of the tickets. I have to consider holidays, weekends and the non-official hours. If any ticket is created during holidays, weekends and the non-official hours I have to calculate the response time of our team accordingly. I also have to carry forward the remaining time if ticket is created 5 minutes before the closure of business hours (17:30). Trying to implement the logic for these reasons.
Please see below the logic that I have implemented and trying to show in one column (PResponseTime). Is this error because of so many conditions that I am using in my code? Can you please suggest another approach for the below piece of code?
// ---------------* Ticket (Priority-1 and Priority-2) created on holiday *--------------------------------------------
If(Priority='Priority-1' or Priority='Priority-2' and Match(CreateDate, $(vHoliday)) and Match(Date(CreateDate+1, 'DD/MM/YYYY'), $(vHoliday)) and WeekDay(CreateDate+1) <> 'Fri', Timestamp#(Date(CreateDate+2) &' 10:00', 'DD/MM/YYYY HH:mm'),
If(Priority='Priority-1' or Priority='Priority-2' and Match(CreateDate, $(vHoliday)) and Match(Date(CreateDate+1, 'DD/MM/YYYY'), $(vHoliday)) and WeekDay(CreateDate+1) = 'Fri', Timestamp#(Date(CreateDate+5) &' 10:00', 'DD/MM/YYYY HH:mm'),
If(Priority='Priority-1' or Priority='Priority-2' and Match(CreateDate, $(vHoliday)) and Match(Date(CreateDate+3, 'DD/MM/YYYY'), $(vHoliday)) and WeekDay(CreateDate) = 'Fri', Timestamp#(Date(CreateDate+4) &' 10:00', 'DD/MM/YYYY HH:mm'),
If(Priority='Priority-1' or Priority='Priority-2' and Match(CreateDate, $(vHoliday)) and WeekDay(CreateDate) <> 'Fri', Timestamp#(Date(CreateDate+1) &' 10:00', 'DD/MM/YYYY HH:mm'),
If(Priority='Priority-1' or Priority='Priority-2' and Match(CreateDate, $(vHoliday)) and WeekDay(CreateDate) = 'Fri', Timestamp#(Date(CreateDate+3) &' 10:00', 'DD/MM/YYYY HH:mm'),
// --------------* Ticket (Priority-3 and Priority-4) created on holiday *--------------------------------------------
If(Priority='Priority-3' or Priority='Priority-4' and Match(CreateDate, $(vHoliday)) and Match(Date(CreateDate+1, 'DD/MM/YYYY'), $(vHoliday)) and WeekDay(CreateDate+1) <> 'Fri', Timestamp#(Date(CreateDate+2) &' 11:00', 'DD/MM/YYYY HH:mm'),
If(Priority='Priority-3' or Priority='Priority-4' and Match(CreateDate, $(vHoliday)) and Match(Date(CreateDate+1, 'DD/MM/YYYY'), $(vHoliday)) and WeekDay(CreateDate+1) = 'Fri', Timestamp#(Date(CreateDate+5) &' 11:00', 'DD/MM/YYYY HH:mm'),
If(Priority='Priority-3' or Priority='Priority-4' and Match(CreateDate, $(vHoliday)) and Match(Date(CreateDate+3, 'DD/MM/YYYY'), $(vHoliday)) and WeekDay(CreateDate) = 'Fri', Timestamp#(Date(CreateDate+4) &' 11:00', 'DD/MM/YYYY HH:mm'),
If(Priority='Priority-3' or Priority='Priority-4' and Match(CreateDate, $(vHoliday)) and WeekDay(CreateDate) <> 'Fri', Timestamp#(Date(CreateDate+1) &' 11:00', 'DD/MM/YYYY HH:mm'),
If(Priority='Priority-3' or Priority='Priority-4' and Match(CreateDate, $(vHoliday)) and WeekDay(CreateDate) = 'Fri', Timestamp#(Date(CreateDate+3) &' 11:00', 'DD/MM/YYYY HH:mm'),
// -------------------------* Ticket created before InTime *-------------------------------------------------
If(Priority='Priority-1' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') < Interval($(vInTime),'HH:mm') and WeekDay(CreateTimestamp) <> 'Sat' and WeekDay(CreateTimestamp) <> 'Sun', Timestamp#(CreateDate&' 10:00', 'DD/MM/YYYY HH:mm'),
If(Priority='Priority-2' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') < Interval($(vInTime),'HH:mm') and WeekDay(CreateTimestamp) <> 'Sat' and WeekDay(CreateTimestamp) <> 'Sun', Timestamp#(CreateDate&' 10:00', 'DD/MM/YYYY HH:mm'),
If(Priority='Priority-3' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') < Interval($(vInTime),'HH:mm') and WeekDay(CreateTimestamp) <> 'Sat' and WeekDay(CreateTimestamp) <> 'Sun', Timestamp#(CreateDate&' 11:00', 'DD/MM/YYYY HH:mm'),
If(Priority='Priority-4' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') < Interval($(vInTime),'HH:mm') and WeekDay(CreateTimestamp) <> 'Sat' and WeekDay(CreateTimestamp) <> 'Sun', Timestamp#(CreateDate&' 11:00', 'DD/MM/YYYY HH:mm'),
// ------------------------------* Ticket created after OutTime and not friday *------------------------------------
If(Priority='Priority-1' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') > Interval($(vOutTime),'HH:mm') and WeekDay(CreateTimestamp) <> 'Fri', Timestamp#(Date(CreateDate+1) &' 10:00', 'DD/MM/YYYY HH:mm'),
If(Priority='Priority-2' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') > Interval($(vOutTime),'HH:mm') and WeekDay(CreateTimestamp) <> 'Fri', Timestamp#(Date(CreateDate+1) &' 10:00', 'DD/MM/YYYY HH:mm'),
If(Priority='Priority-3' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') > Interval($(vOutTime),'HH:mm') and WeekDay(CreateTimestamp) <> 'Fri', Timestamp#(Date(CreateDate+1) &' 11:00', 'DD/MM/YYYY HH:mm'),
If(Priority='Priority-4' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') > Interval($(vOutTime),'HH:mm') and WeekDay(CreateTimestamp) <> 'Fri', Timestamp#(Date(CreateDate+1) &' 11:00', 'DD/MM/YYYY HH:mm'),
// --------------------* Ticket created after OutTime on friday *-----------------------------------------
If(Priority='Priority-1' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') > Interval($(vOutTime),'HH:mm') and WeekDay(CreateTimestamp) = 'Fri', Timestamp#(Date(CreateDate+3) &' 10:00', 'DD/MM/YYYY HH:mm'),
If(Priority='Priority-2' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') > Interval($(vOutTime),'HH:mm') and WeekDay(CreateTimestamp) = 'Fri', Timestamp#(Date(CreateDate+3) &' 10:00', 'DD/MM/YYYY HH:mm'),
If(Priority='Priority-3' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') > Interval($(vOutTime),'HH:mm') and WeekDay(CreateTimestamp) = 'Fri', Timestamp#(Date(CreateDate+3) &' 11:00', 'DD/MM/YYYY HH:mm'),
If(Priority='Priority-4' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') > Interval($(vOutTime),'HH:mm') and WeekDay(CreateTimestamp) = 'Fri', Timestamp#(Date(CreateDate+3) &' 11:00', 'DD/MM/YYYY HH:mm'),
// -----------------* Ticket created after InTime and before OutTime (within the SLA time) *------------------
If(Priority='Priority-1' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') >= Interval($(vInTime),'HH:mm') and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') <= Interval($(vOutTime),'HH:mm') and Time(Interval($(vOutTime)-CreateTime), 'h:mm') > Time#('1', 'h:mm'),TimeStamp(Num(CreateTimestamp)+(1/24),'DD/MM/YYYY HH:mm'),
If(Priority='Priority-2' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') >= Interval($(vInTime),'HH:mm') and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') <= Interval($(vOutTime),'HH:mm') and Time(Interval($(vOutTime)-CreateTime), 'h:mm') > Time#('1', 'h:mm'),TimeStamp(Num(CreateTimestamp)+(1/24),'DD/MM/YYYY HH:mm'),
If(Priority='Priority-3' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') >= Interval($(vInTime),'HH:mm') and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') <= Interval($(vOutTime),'HH:mm') and Time(Interval($(vOutTime)-CreateTime), 'h:mm') > Time#('2', 'h:mm'),TimeStamp(Num(CreateTimestamp)+(1/12),'DD/MM/YYYY HH:mm'),
If(Priority='Priority-4' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') >= Interval($(vInTime),'HH:mm') and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') <= Interval($(vOutTime),'HH:mm') and Time(Interval($(vOutTime)-CreateTime), 'h:mm') > Time#('2', 'h:mm'),TimeStamp(Num(CreateTimestamp)+(1/12),'DD/MM/YYYY HH:mm'),
'NA')))))))))))))))))))))))))) as PResponseTime
Regards,
Romila.
