Forum Discussion

Cypher294's avatar
Cypher294
Frequent Visitor
8 years ago
Solved

Priority Based SLA Calculation

HI,

 

I've got a question about a combined statement

 

In my source data we have the ticket information "priority" and runtime in hours.

Now I've want to create a statement about a SLA breach status.

 

In my example the SLA values would be

 

Priority Very High - 4 Hours

Priorty High - 6 Hours

Priority Medium - 10 hours

Priority Low - 20 hours

 

Depending on the value of " Ticket runtime in hours" and the "priority" of the ticket the Column " SLA State" needs to be set to " SLA OK" or "SLA Violated" if the " Ticket Runtime in hours" is equal or higher then the values explained before the state needs to be set to " SLA Violated" otherwise it needs to be set to " SLA OK.

 

 

Thanks for help

 

 

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Cypher294,

     

    Suppose you have such a table to list SLA values.

     

    Then, in data table, create a calculated column.

    SLA STATE =
IF (
    Table_1[Ticket Runtime in hours]
        >= LOOKUPVALUE ( Table_2[Runtime], Table_2[Proority], Table_1[Priority] ),
    "SLA Violated",
    "SLA OK"
)

     

    Best regards,

    Yuliana Gu

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi Cypher294,

     

    Suppose you have such a table to list SLA values.

     

    Then, in data table, create a calculated column.

    SLA STATE =
IF (
    Table_1[Ticket Runtime in hours]
        >= LOOKUPVALUE ( Table_2[Runtime], Table_2[Proority], Table_1[Priority] ),
    "SLA Violated",
    "SLA OK"
)

     

    Best regards,

    Yuliana Gu