Weighted median computation

[akshatkumar87]

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

[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 ?

[pcatterson · Accepted solution]

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

[akshatkumar87]

Wonderful thanks a lot !!

[pcatterson · Accepted solution]

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

[jdunkerley79]

Mostly for interest I tried to recreate the CReW Macro with a dynamic grouping input.

Lets you pick the columns to group by and returns the group names with the computed weighted median.

 

Details on how I made the macro are at https://jdunkerley.co.uk/2016/06/10/creating-user-controlled-groupings-in-a-weighted-median-alteryx-...

[akshatkumar87]

Can you reupload with the older version of Alteryx i cannot install this one because this was made on older version?

[jdunkerley79 · Accepted solution]

Try the attached.