1 of 1 people found this helpful
sometimes simple thoughts may not be simple, if you can share a sample workbook, it will be easier for people here to help
Hi Ken Flerlage,
Thanks for replying. I've tried that and it does indeed give me a line, but it plots the wrong shape. For example, the maximum session count should be around 5. When I remove ID it shoots up to 25. Do you know how I can keep the same shape and values? Cheers
I think there must be some issue with your data then. For example, 10:27 AM shows a total of 26 sessions. If I look at the raw data, I see this:
If we sum up the values for the 6 different sessions, we get 26.
I think your join is causing this. The number of active sessions comes from one table while the join is adding in another table which duplicates these records. Since that value is always the same for all those duplicate records, you should be able to safely use MIN, MAX, or AVG instead of SUM.
See attached workbook.