Forum Discussion

ashaikh's avatar
ashaikh
Icon for Helper III rankHelper 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
Icon for Resident Rockstar rankResident Rockstar
9 years ago

It doesn't look like it unless you filter to only include "YES' values...  Please mock up what you want the final table to look like...?

 

FOrrest

ashaikh's avatar
ashaikh
Icon for Helper III rankHelper III
9 years ago

Solution should be something like this

 

SLA Check Priority ticket count sla%
yes            High     90                90%
no             High     10                10%
yes            low       75                75%
no             low       25                25%

  • fhill's avatar
    fhill
    Icon for Resident Rockstar rankResident 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
      Icon for Helper III rankHelper III
      9 years ago

      Thanks.

       

      That works.