3 Replies Latest reply on Nov 18, 2016 12:42 PM by Sean Keleher

    Average of Averages

    Sean Keleher

      I've been searching for a while in the Community and haven't found an answer to this question.

       

      Can anyone please explain how to calculate an average of average values in Tableau?

       

      For example with the following data:

      UserDayUsage
      A110
      A250
      A320
      B160
      B3100
      C11000
      C220
      C320
      D340

       

      Tableau automatically calculates the average of all usages by totaling everything to 1320 and dividing by 9 entries to get 146.7.

       

      I'm interested to see the average of averages per user, so I got Tableau to create this table for me:

       

      User
      Total UsageNumber of DaysPer User Average
      A80326.7
      B160280
      C10403346.7
      D40140

       

      Using this data, the Average of Per User Averages would be made by totaling to 493.3 and dividing by 4 users to get 123.3.

      So far I haven't found a method to calculate the average of the Per User Average in Tableau. Any help would be appreciated!