7 Replies Latest reply on May 17, 2014 6:19 AM by Noah Salvaterra

    How to solve the problem of a new aggregation based on the other aggregation

    Qin Wang

      Hi folks,


      I have a problem. First, I have a calculated field named "Average gain" which is "AVG([Posttest answer])-AVG([Pretest answer])". Then I want to know the standard deviation of this "Average gain", but "STDEV([Average gain] )" is wrong as Tableau complains "STDEV (an aggregate function) is already an aggregation, and cannot be further aggregated." How can I solve this problem? I need this SD!!!