3 Replies Latest reply on Sep 14, 2016 10:03 AM by Andrew Watson

    sumup hourly data with calculated field

    Marc Maleika

      Hello,

       

      we are tracking how many people enter our store on a hourly basis. The data looks as follows

       

      Time          Visitor     Date

      0000AM          0          010616

      ..

      0300PM          5          010616

      0400PM          6          010616

      2300PM          0          010616

      0000AM         0          020616

      ...

      0200PM          2          020616    

      ...

       

      I would like to sum up all visitors per day with a calculated field.

       

      Many thanks.