2 Replies Latest reply on Aug 15, 2016 10:28 AM by Clayton Chapman

    Trouble finding average number of records by weekday by hour

    Clayton Chapman

      Howdy,

       

      The issue that I'm running into is that I am trying to get the average count of tickets that are coming in by weekday and hourly. If my date range was a constant this would be easy as I could just say well there are 7 weeks so take total tickets/7. But I am trying to have it be a little more interactive and allow the user to decide which dates to pick. So their may be 7 instances of Monday at 6 am or 10 instances depending on the date range.

       

      I've tried a few things here and there to get it to work, but I am just at a lost on what I might be doing wrong. Attached is an example of the problem I am having.