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

    Aggregating Hourly Data to Calculate Daily Averages

    Marc Maleika

      Hello,

       

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

       

      Background:

      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.

       

      Question:

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

       

      Many thanks for your help!