1 Reply Latest reply on Jan 21, 2019 5:57 AM by Ombir Rathee

    normalize value and then calculate summary stats

    Christian Setzkorn

      I am trying to use this min max normalization to create a summary stats using a calculated field:

       

      Median( (x - MIN(x))/(MAX(x) - MIN(x)) )

       

      but I get:

       

      Cannot mix aggregate and non aggregate arguments

       

      What can I do to achieve the above please? The above has to recalculated for different filter settings. Thanks!