topic Re: SLA time in App Development

SLA time

Raju_6952 — Fri, 27 Oct 2023 10:45:38 GMT

Hi,

I have incident creation time field in my data model and have a requirement that need to caculate SLA time remaing for each incident (here SLA time defined is 24 hrs for each incident once the incident is generated).

for example my idea is that need to add 24 hrs for each incident and then subtract incident creation time .

any suggestions will be highly appreciated.

Re: SLA time

maheshkuttappa — Fri, 27 Oct 2023 14:37:22 GMT

Can you post sample data for creation time?

Re: SLA time

Raju_6952 — Fri, 27 Oct 2023 16:43:52 GMT

Hi @maheshkuttappa ,'

Please find the sample data below for your reference.

In above case for incident_creation Time I need to add exact 24 hrs for each incident I.e the output required 10/28/2023 5:29:51 PM (which means 24 hours SLA time for that incident after its created.

Re: SLA time

maheshkuttappa — Sat, 28 Oct 2023 00:07:18 GMT

You use SLATime1 or SLATime 2 . I suggest storing SLA time as a variable.

T:
Load
*,
Timestamp(StartTime +'24:00:00','MM/DD/YYYY hh:mm:ss') as SLATime1,
Timestamp(StartTime +'1','MM/DD/YYYY hh:mm:ss') as SLATime2;
;
Load Date#(StartTime,'MM/DD/YYYY hh:mm:ss') as StartTime,
;
Load * Inline
[StartTime
10/28/2023 5:29:51];

Re: SLA time

Raju_6952 — Sat, 28 Oct 2023 05:34:37 GMT

Hi @maheshkuttappa ,

Thnks for the hint but here the start time in inline load should be dynamic for example it should add 24 hrs to the incident creation time .

Re: SLA time

anat — Sat, 28 Oct 2023 07:15:57 GMT

You can add 1 day to your incident creation time field

Re: SLA time

Raju_6952 — Sat, 28 Oct 2023 07:18:52 GMT

Hi @anat ,

That is where I am struggling, I tried several syntax but that output of after adding 24 hrs is getting wrong

Re: SLA time

anat — Sat, 28 Oct 2023 07:39:13 GMT

Timestamp(YourField+Time#(24,'hh'))

Re: SLA time

anat — Sat, 28 Oct 2023 07:49:29 GMT

LOAD *,Timestamp(StartTime+1,'MM/DD/YYYY hh:mm:ss') as NF;
Load Date#(StartTime,'MM/DD/YYYY hh:mm:ss') as StartTime,
;
Load * Inline
[StartTime
10/27/2023 5:29:51
10/27/2023 5:45:51
];

Re: SLA time

Raju_6952 — Sat, 28 Oct 2023 10:42:08 GMT

Hi @anat

by Using this Timestamp(YourField+Time#(24,'hh'))

start time =Incident_CreationTime

Re: SLA time

maheshkuttappa — Sat, 28 Oct 2023 13:47:34 GMT

This should work, can you share your script?

Re: SLA time

Raju_6952 — Sat, 28 Oct 2023 15:36:03 GMT

Hi,

@maheshkuttappa ,

its working but when I added to straight table its keep on loading and shows out of calculation memory.