Forum Discussion
SLA calculation.
Hi, I am doing reports for one of my support projects where i need to calculate SLA. My Source is VSO query. I have Resolved date and SLA target date. I have added custom column to calculate SLA ...
I think you can just create a measure using CALCULATE and DIVIDE.
So
Number of Tickets resolved =DISTINCTCOUNT(<TicketID column>)
Number of Tickets with in SLA = CALCULATE([Number of Tickets resolved],<SLA Column>="yes")
SLA % = DIVIDE([Number of Tickets with in SLA],[Number of Tickets resolved])