1 Reply Latest reply on Mar 29, 2016 5:52 AM by jon rios

    Min value of an Average... "Error... Cannot Aggragate an Aggregate

    jon rios

      i have a calculation which is a MA... WINDOW_AVG(SUM([Not 2014]), -1, 1).   i want to find the Minimum Value of this MA... MIN(WINDOW_AVG(SUM([Not 2014]), -1, 1))

       

      i get an error.. Agrument to MIN() is already an aggregate, cannot be further aggregated...

       

      this MovingAverage dataset has a minimum value, not sure why Tableau cannot pull Min value for this MA.

       

      thanks for an explanation and how to accomplish this...