This content has been marked as final. Show 3 replies
I'm trying to create a dual axis with a sum and average of calls per hour. Each week is represented as mark within the corresponding hour range. Problem is, I cant quite get the right level of aggregation on my average.
In my source data, each day could be represented multiple times either by a different queue or 15 minute increment.. I've provided an example of my source data below.