5 Replies Latest reply: Mar 4, 2016 3:22 PM by Sunny Talwar RSS

    Average of Count by Hour

    Nick Listerman

      I have incident data stored like the below and I need to calculate the average number of tickets created by hour each day.  I know I need to use AGGR() but I just can't quite get it right.

       

      TicketDateHour
      Ticket13/4/20161
      Ticket23/5/20161
      Ticket33/5/20161
      Ticket43/6/20161
      Ticket53/6/20161
      Ticket63/6/20161
      Ticket73/6/20161
      Ticket83/6/20161
      Ticket93/6/20161
      Ticket13/4/20162
      Ticket23/5/20162
      Ticket33/5/20162
      Ticket43/6/20162
      Ticket53/6/20162
      Ticket63/6/20162
      Ticket73/6/20162
      Ticket83/6/20162
      Ticket93/6/20162

        

      In the end I want to see:

      HourAverage
      13
      23