1 Reply Latest reply on Sep 17, 2018 8:03 AM by Shinichiro Murakami

    Remove Duplicated Median

    Jinjia Lin

      Been at this for hours on end with no outcome.

       

      I want to find the median for my data, but it only appears when I lists out the elements on the columns, like this:

      duplicated median.jpg

       

      my data consists of schools on the columns, and then grade levels on the rows.

      I managed to find a hacky solution by hiding all but one column, but the isolated column will disappear when I toggle a parameter on my dashboard, due to presence of other filters.

       

      I am wondering if there is a way to collapse all of these into one column, using an elegant solution.

       

      Was thinking of something like {include [school]: window_median([percentage of total])} but apparently LOD expressions cannot be used in conjunction with table calcs?

       

      Appreciate any kind assistance!