4 Replies Latest reply on Jun 8, 2015 1:09 PM by Aaron Mackey

    Get Max of Averages

    Aaron Mackey

      Hello everyone,

       

      How would I go about getting the max value of a column's averages.  MAX(AVG([Value]) does not work because I am trying to aggregate on an aggregate.

       

      For example, my data looks like the following:

      Item NumberCategoryValue

      1

      Chairs1
      2Chairs3
      3Chairs4
      4Rug3
      5Rug5

       

      I display the following table in Tableau using AVG([Value])

      CategoryAvg Value
      Chairs2.66
      Rug4

       

      Now I need to get the MAX of the averages being displayed in Tableau.

       

      Thank you!