I want to do a servicelevel calculation which runs for the whole duration of a day in the callcenter. This calculation is to be done for each skillset. As the realtime display for the skillset shows data for the past 15 minutes running, i need to be able to get data from earlier in the day into the realtime display. The calculation is as follows:
Number of calls answered MINUS number of calls answered after threshold DIVIDED by number of calls offered MULTIPLIED by 100%.
Exampel: (450-50)/500*100% = 80% servicelevel
The question is: how do i keep the data in all present columns on the 15 minutes running interval and then add a coulumn where the servicelevel calculation for the whole day is present?
Number of calls answered MINUS number of calls answered after threshold DIVIDED by number of calls offered MULTIPLIED by 100%.
Exampel: (450-50)/500*100% = 80% servicelevel
The question is: how do i keep the data in all present columns on the 15 minutes running interval and then add a coulumn where the servicelevel calculation for the whole day is present?