Forum Discussion

pswain's avatar
pswain
Helper I
5 years ago

How can we SLA reports using Service Now data

Hi all,

 

How can I create SLA reports using the below data. 

 

I need to calculate opened and resolved state difference in Power BI , How it can be acheieved  ? ex: opened -closed = x

 

Please @mention me if you need more information 

 

 

Regards,

Prasanjit

 

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    pswain < not very clear

    you can have a column

    datediff([opened_at],[closed_at] ,hour) //it can minute, day anything you want

     

    you can compare

    if( datediff([opened_at],[closed_at] ,hour)<=2,1,0) //change as per need

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    Hi,

    Opened and closed entries are left aligned so they look like text entries.  Ensure that they are proper date/time entries.  Once they are, this calculated column formula should work

    =[closed_at]-[opened_at]

    Hope this helps.