With the below data, want to measure the time series graph with 30 sec resolution, how many are logged in and how many are Ready and how many are Busy. how to group by agent and find the status and sum the agents based on the status at every 30 sec time intervel
Time Agent Status
9:10 agent1 Login
9:20 agent2 Login
9:30 agent1 Busy
9:35 agent1 Ready
9:36 agent1 Logout
9:40 agent2 Ready
9:44 agent3 Login
9:45 agent4 Login
- You dont have seconds in your timestamp, hence it does not make any sense to use 30 seconds interval.
- What have you tried? What error/issue have you encountered?
I have just given the reference data. we can try for each miniute with above data. what is the approch to get the stats for every minute.
as the agent1 is login at 9:10 it should count at 9:11 and 9:12 and 9:13 also as he still login.