Is it possible to sum up activities of an agent for an interval of an agent in a bar chart.
8:00 to 8:30 - 10 Mins break and 20 mins on call
8:30 to 9:00 - 30 mins on call
9:00 to 9:30 - 10 mins break and 20 mins on call.
I need a chart like the above in qlikview.
Ya but the problem is that if for example an agent goes on break at 8:27 and returns at 8:47. It shows the 20 minutes in the 8:30 bar but instead I want it to break it like 3 mins for the 8:00 bar and 17 mins in the 8:30 bar.
You may also need to use the IntervalMatch() function, have a look at this blog post IntervalMatch by Henric.
But unless you share some sample data I can only guess.
You may get the sample by clicking on the link below:
I have explain in more detail the issue.