How can we SLA reports using Service Now data

[pswain]

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

[Ashish_Mathur]

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.

[amitchandak]

@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