3 Replies Latest reply: Dec 3, 2015 2:47 PM by ANDY SALLEE RSS

    Average count by hour

    ANDY SALLEE

      Good evening Community,

       

      I have been working on this and not able to make it work as would like. Wish to compare average count per hour to a daily count per hour. I have the hour fine however not able to get the average per hour except in total format not across by hour for all days. Below is by hour for single day from filter selection. Would like the Average to be all tickets in database, no missin

       

      Using Hour(TimeField) to select the hour

      Counting by Count(TicketID)

      Location Name is a field for multiple locations

       

      Hourly.gif

      Here is what currently using to get this result, I am sure missing something small just not able to determine what.

       

      avg(aggr(Count( {1} distinct TicketNo) , LocationName))

       

      Thanks in advance,

      Andy

       

      Attached sample QVF Message was edited by: Andy Sallee