2 Replies Latest reply: Feb 20, 2013 8:24 AM by Nick Listerman RSS

    Dimension to display every hour over the last 24 hours

    Nick Listerman

      I'm attempting to show the number of incoming calls over the last 24 hours even if the value is zero.  My current dimension is:

       

           timestamp(round(inc_call_time,(1/24)))

       

      This rounds the call times to the nearest hour and works properly but when I filter by a call type and that call type does not have a call during an hour, it doesn't show zero but it skips the hour.  I need to represent that hour with a zero.  I know it's doing this because my dimension calculates its values based on the inc_call_time field and that call type does not have a call within that hour.

       

      Is there a dimension calculation I can use to display all hours in the last 24 hours not based on a time/date field in my data?