Forum Discussion

gpauli200's avatar
gpauli200
Frequent Visitor
8 years ago
Solved

SLA Reporting Help - Calculated Column Formula?

Hello, I am having trouble figuring out how to report on SLA targets. I’ve been reading other user questions here, but I am having trouble applying their solutions to my data.   I have a table wit...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi,

    as far as I see this problem, you should use DATEDIFF function to calculate difference between dates. In it"s 3rd parameter you can set the difference to a hour based format. 
    After that you can solve this with a simple IF and AND function combo. 

    I bet It can be solved less complicated but here is my calculated column for that for that:

    SLA = IF(AND(Table1[Priority]="Medium",DATEDIFF(Table1[Create_Date],Table1[Resolved Date],HOUR)<=16),"In SLA",IF(AND(Table1[Priority]="Low",DATEDIFF(Table1[Create_Date],Table1[Resolved Date],HOUR)<=72),"In SLA",IF(AND(Table1[Priority]="High",DATEDIFF(Table1[Create_Date],Table1[Resolved Date],HOUR)<=8),"In SLA","Out SLA")))

    and here is the table with the resoult:


    Hope I could help.

    Barna

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi,

as far as I see this problem, you should use DATEDIFF function to calculate difference between dates. In it"s 3rd parameter you can set the difference to a hour based format. 
After that you can solve this with a simple IF and AND function combo. 

I bet It can be solved less complicated but here is my calculated column for that for that:

SLA = IF(AND(Table1[Priority]="Medium",DATEDIFF(Table1[Create_Date],Table1[Resolved Date],HOUR)<=16),"In SLA",IF(AND(Table1[Priority]="Low",DATEDIFF(Table1[Create_Date],Table1[Resolved Date],HOUR)<=72),"In SLA",IF(AND(Table1[Priority]="High",DATEDIFF(Table1[Create_Date],Table1[Resolved Date],HOUR)<=8),"In SLA","Out SLA")))

and here is the table with the resoult:


Hope I could help.

Barna