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...
i found Window_Min() which, i think, allows to find Min value of aggregate. Please confirm if this is the best way to do this...