i am trying to automate the SLA Timing based on the app refresh time. But it is not coming, i used below expression to get the SLA timing, but no luck. Please help me out, to get the SLA timings.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Expression 1:
=pick(match([App Name],'APP1','APP2','APP3'),
interval(timestamp([Reload Finish])-timestamp(Date(floor([Reload Finish]),'YYYY-MM-DD')&' 05:30:00','YYYY-MM-DD hh:mm:ss')),
interval(timestamp([Reload Finish])-timestamp(Date(floor([Reload Finish]),'YYYY-MM-DD')&' 11:00:00','YYYY-MM-DD hh:mm:ss')),
interval(timestamp([Reload Finish])-timestamp(Date(floor([Reload Finish]),'YYYY-MM-DD')&' 11:00:00','YYYY-MM-DD hh:mm:ss')))
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Expression 2:
pick(match([App Name],'APP1','APP2','APP3'),
Interval(Date#(LogTimeStamp,'YYYY-MM-DD hh:mm:ss') - Date#(Date(LogTimeStamp)&' '&'05:30:00','YYYY-MM-DD hh:mm:ss') ,'hh:mm:ss'),
Interval(Date#(LogTimeStamp,'YYYY-MM-DD hh:mm:ss') - Date#(Date(LogTimeStamp)&' '&'11:00:00','YYYY-MM-DD hh:mm:ss') ,'hh:mm:ss'),
Interval(Date#(LogTimeStamp,'YYYY-MM-DD hh:mm:ss') - Date#(Date(LogTimeStamp)&' '&'11:00:00','YYYY-MM-DD hh:mm:ss') ,'hh:mm:ss'))
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
