topic SLA calculation in App Development

SLA calculation

Sharad02 — Thu, 29 Sep 2022 12:14:08 GMT

Hii Team,

I wanted Calculated SLA from This table given below .

SLA formula given is "The SLA is calculated as the sum of “Open, Assigned, Work in Progress” statuses in the “Value” column."

How do we calculate it?

In backend as well as in fronted .

Mark_Little — Thu, 29 Sep 2022 12:28:18 GMT

What are you wanting the SUM of?

If it is the time Differ between Start and end you will want to look at the Interval function

Script.

Interval(End - Start, 'D hh:mm' ) as Timetaken,

Could add if to limit the value if you only want the values Open, Assigned, Work in Progress

In chart

SUM({<Value={'Open',' Assigned',' Work in Progress'}>}Timetaken

sidhiq91 — Thu, 29 Sep 2022 12:47:49 GMT

@Sharad02 Could you please be more specific with your requirement? Not sure how the SLA is calculated from your explanation.