Weighted median computation

Hey guys i am trying to do wieghted median over two columns which is the best macro for the same ?

Used crew macro but getting into config trouble the macro works well but does not give the group by ids in the output. In the config i grouped by a column for ex. id and it has to calculate wieghted median for each of those id. The output does not show me the id just the weighted median values.

Output i got

weighted median

5
3
2.785714
4
3
4.208333

Desired output

Id weighted median

1 5
2 3
3 2.785714
4 4
5 3
6 4.208333

Workflow

Tips and Tricks

Macros

Transformation

Interface Tools

Iterative Macro

Accepted answers

pcatterson

I made a small change to the inner workings of the default CREW macro. That should do what you need.

CReW_WeightedMedian2.yxmc

pcatterson

i'm attaching a slightly improved version of the adapted weighted median macro.

CReW_WeightedMedian2.yxmc

jdunkerley79

Try the attached.

Weighted Median.yxmc

All comments

pcatterson

There is a good Weighted Median tool within the CREW macros:

http://community.alteryx.com/t5/Engine-Works-Blog/Crew-Macro-Pack-New-Release-Coming-Soon/ba-p/3642

akshatkumar87

Thanks a lot the macro works well but does not give the group by ids in the output. In the config i grouped by a column for ex. id and it has to calculate wieghted median for each of those id. The output does not show me the id just the weighted median values.

Output i got

weighted median

5
3
2.785714
4
3
4.208333

Desired output

Id weighted median

1 5
2 3
3 2.785714
4 4
5 3
6 4.208333

Any clue ?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703