Forum Discussion

ashaikh's avatar
ashaikh
Helper III
9 years ago
Solved

SLA calculation

Hello Guys,   I have a scenario here; I need to calulate SLA percentage based on the Priority.   I have 3-columns: Has Met SLA - Says if it has met SLA Priority - Priority Ticket Id - Id of ...
Need Help
  • fhill's avatar
    fhill
    9 years ago

    Tickets = COUNT(Table1[Ticket ID])

    SLA%_2 = COUNT(Table1[SLA_Check - Text]) / CALCULATE(COUNT(Table1[SLA_Check - Text]), ALL(Table1[SLA_Check - Text]))

     

fhill's avatar
fhill
Resident Rockstar
9 years ago

Tickets = COUNT(Table1[Ticket ID])

SLA%_2 = COUNT(Table1[SLA_Check - Text]) / CALCULATE(COUNT(Table1[SLA_Check - Text]), ALL(Table1[SLA_Check - Text]))

 

ashaikh's avatar
ashaikh
Helper III
9 years ago

Thanks.

 

That works.