4 Replies Latest reply on Sep 12, 2016 9:09 AM by Marc Maleika

    Aggregating Hourly Data to Calculate Daily Averages

    Marc Maleika



      I am new to Tableau - so still trying to figure out the many possibilities. I am working on the following:



      1) We track on a hourly basis how many customers are entering our stores.

      2) We want to understand on a daily basis how many people enter each store and how many people bought something at that store.

      3) Visitors are tracked on a hourly basis.

      4) #Items_bought is tracked on a daily basis.



      How do I aggregate the hourly visitor data to daily in a calculated field.


      Many thanks for your help!