Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
Is it possible to sum up activities of an agent for an interval of an agent in a bar chart.
Example
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.
Many Thanks,
Hasvine
What is your table structure ?
A stacked Bar Chart may well suffice.
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.
can u provide the sample data...
Hi All,
You may get the sample by clicking on the link below:
Sum activities in interval of 30 mins
I have explain in more detail the issue.
Many thanks,
Hasvine
That is just the link to this threas.
Hi Bill,
I have added the QVW.
Many thanks for your help.
KR,
Hasvine
Please reduce the data in your QVW as file size is large