How do I get the Medium of a BeastMode result?

Hello,

I created a Beastmode that is giving me the aggregate percentage of all the values in those fields. I need to get the medium, is there a way to do this.

Calculation I am using

Answers

  • When you say medium, are you asking for median, mean, or mode?

  • I am looking for the median, thanks!

  • Median isn't able to be calulcated in a beast mode but you can do it within a Magic ETL using a group by tile.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • Hey @GrantSmith , I am selecting median in the group by but I am not getting the expected result.

    Is there an additional step I am missing. The median is being based on a previous calculation.