SLA calculation

[Sharad02]

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 .

Number	State	Item	Opened by	Start	End	Value	Stage
TASK1234	Closed Complete	Service	Support	03-01-2022 11.56.49		Closed Complete	Completed
TASK1234	Closed Complete	Service	Support	03-01-2022 09.31.58	03-01-2022 10.00.31	Open	Completed
TASK1234	Closed Complete	Service	Support	03-01-2022 10.00.31	03-01-2022 10.19.41	Pending(Awaiting User Info)	Completed
TASK1234	Closed Complete	Service	Support	03-01-2022 10.19.41	03-01-2022 11.56.49	Work in Progress	Completed

[Mark_Little]

Hi @Sharad02 

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]

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