Calculated Field Advice

[donnalouiseb74]

Hi Following on from my post about SLAs I think I need to do this via a calculated field so I can use this as KPI field.

So... I think I need to something like this = If(Count([Ticket_CloseMonthYear]) && Count([Ticket_WithinCloseSLA)=1)... then I get run out of ideas... how do I divide the results of the counts to give me a percentage which I could express as a within SLA MM YY and out SLA MM YY

If it would was writing this out by hand, I would do the following...Tickets Closed Nov 2015 within SLA/Total Tickets Closed Nov 2015* 100 = November within SLA.

I need the month expression so I can track historical performance!

Any advice would be greatfully recieved.

Thanks

 

[scottsen]

Total Tickets := COUNTROWS(Tickets)
Total Tickets in SLA := CALCULATE([Total Tickets], Tickets[WithinSLA] = 1)
Tickets in SLA % := DIVIDE([Total Tickets in SLA], [Total Tickets])