Clarification: I can get this to work in straight table by adding the user and date as expressions, using max as the definition of login, and using sum in the total mode.
I want to make a pie chart showing the distribution of times for each activity: call times, lunch, after call work, etc. I need the login time so I can calculate the idle time - login minus everything else. The pie chart won't have the dimensions, so I can't figure out how to get a pie chart to work for more than one day and one agent.
Is this possible?
What I would like is a pie chart that shows the percentage of time the agent spent during each activity. One of the slices will be 'idle' time when they aren't doing anything but waiting for the next call. I need the login time so that I can subtract the things they did to get that idle time.
Your expression works great in a straight table, but if I have those dimensions in the pie chart, I don't get what I want. Unless I am missing something with pie charts.
I may have to live with the straight table for aggregations and use the pie chart only for one day and one agent.