Attached is an excel file from a table in the Cisco UCCX call manager system used by our helpdesk. I need help in creating a load script that will calculate the amount of time per day per technician is in each State Event such as logged in, ready, talking, etc.
I believe for each row, I need to subtract the time of the next row from the current row and that will give me the time for that particular event such as
John Smith
6/15/2011 1:13:41 PM
Not Ready
John Smith
6/15/2011 1:17:24 PM
Ready
"Not Ready" = 1:17:24 - 1:13:41 or about 3mins 43 seconds.
An exception is for the "log in" and "log out" event. From the database, it seems I need to caculate the "log in" time based on the "log out" time - "log in" time.
What's the best way to do these type of calculations in qlikview?
