2 Replies Latest reply on Oct 25, 2018 8:29 AM by adam jama

    Am I calculating these averages correctly?

    adam jama


      I'm trying to figure out if Im calculating averages correctly.

      The workbook below from tableau public has 3 averages.

      1) average subtotal of each order per weekday.  ( i brought the pill to the viz and clicked on average to get that)

      2) average spent per day by customers on a typical weekday. ( i created a calculated field: [average subtotal ]*[average order per day] )

      3) average number of orders received per weekday. ( I created a calculated field: AVG({INCLUDE [Date] : COUNT([Number of Records])} )

      Tableau Public

      Thanks in advance for your help. Especially number 2, if its correct is there a simpler way to calculate that ?