1 Reply Latest reply on Nov 7, 2018 3:26 PM by Peter Fakan

    Average number of orders per hour

    adam jama

      Hello,

      Im trying to see how many average orders per hour we got last month. Its giving me a number that doesnt make sense.

      Here'es the link to tableau public worksheet.

      Tableau Public

      Also it seems its listing the hours where we did get orders. Would it be possible to list all hours of the day even if there was no orders at those times.

      Thanks in advance for your help.

      Adam,

        • 1. Re: Average number of orders per hour
          Peter Fakan

          Hi Adam,

           

          Is this what you are looking for ?

           

           

          Firstly I turned the totals for column on, changed the aggregation to average, then turned on subtotals, and then turned the totals for column back off again.

           

          Unfortunately I'm not aware of how to get the 'missing' fields to show up when you derive them from a calculated field

           

          HTH

           

          Peter