3 Replies Latest reply on Mar 22, 2018 11:15 PM by Tushar More

    Calls per Hour calculation

    Tim Cady

      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.