How do I get the Medium of a BeastMode result?

jmartinez
jmartinez Member
in Beast Mode

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

image.png

Answers

  • JasonAltenburg
    JasonAltenburg Coach

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

  • jmartinez
    jmartinez Member

    I am looking for the median, thanks!

  • GrantSmith
    GrantSmith Coach

    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!**
  • jmartinez
    jmartinez Member

    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.

    image.png

Categories