11 Replies Latest reply on Jun 27, 2016 12:10 PM by Cheri Beckman

    15-minute time increments, ignoring the Date

    Cheri Beckman

      I need to show the total number of calls received by our call center by time of day, in 15-minute increments, and I need the numbers to reflect the entire year, not each date. 

       

      I have created bins for the time in 15 minute increments --- DATETIME(INT(FLOAT([Start Date]) * (1440 / 15)) / (1440 / 15)) --- but I get a separate column for each date:

       

      I only need one column for the total number of calls received in that 15-minute interval over the entire year.

       

      This is what I want it to look like:

       

      Time#Calls
      7:152045
      7:301230
      7:45912
      8:00321
      8:15322
      8:302234
      8:452012
      9:001719

       

      Appreciate any help!