CR 10, SQL 2008 db
End result: show SLA percentage by a grouped field. Some example desired results:
Emergency = 50%
In Progress = 50%
Example report design:
Rep - SO - Status - WorkDate - SLADeadline
John - 123 - In Progress - 11-1-13 - 10-30-13
Frank - 234 - In Progress - 11-9-13 - 11-12-13
Joe - 456 - Emergency - 11-12-13 - 11-11-13
Sally - 789 - Emergency - 11-10-13 - 11-10-13
If you compare workdate with sladeadline you'll notice 2 workdate's are past the sladeadline. If I add up each status, 2 for each status and then divide those that met the deadline by those that didn't we get 50% for each status.
I'm not sure where to begin with this type of calculation, suggestions please?
IP Logged
