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!