Forum Discussion

taspland's avatar
taspland
Frequent Visitor
5 years ago
Solved

SLA Calculation

Hi, i'm trying to get a correct SLA state however i'm unable to get the data to show correctly. and have no idea how to split the incident and task sla on  I have a table with Ticket ID, Ticket Typ...
Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    Hi, taspland 

    I’ve downloaded your pbix file and I can roughly understand your requirement according to your description, you can try this calculated column:

    SLA STATE =

VAR _incidentsla=RELATED(SLA[incident sla])

VAR _tasksla=RELATED(SLA[Task SLA])

Return

IF(

    [ticket type]="Incident",

    IF(

        [business_duration]>=_incidentsla,

        "SLA Violated","SLA OK"),

        IF(

        [business_duration]>=_tasksla,

        "SLA Violated","SLA OK")

)

    The output is like this:

     

    And you can get what you want.

    You can download my test pbix file below

     

    If you still have a problem, you can explain your expected result in detail with examples.

    How to Get Your Question Answered Quickly 

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
5 years ago

taspland , Table structure is not clear. You need something like this

New column =
var _cnt = countx(filter(SLA, SLA[Priority] = ticket[Priority] && ticket[Business Duration in seconds] <= SLA[incident sla]),SLA[Priority])
return
if(isblank(_cnt), "SLA OK", "Not OK")

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

This can help

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8