community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Batch macro. and multiple filters to create ranks and percentiles

Alteryx Partner

I thought I cracked it with this macro but alas not.  

 

I am trying to create a macro that creates median, quartiles and ranks for different subgroups (I am analyzing a large data file where there are 30+ subgroups for which I need to do these calculations).  

 

The output structure I am looking for would be a single line per department per year with columns for value, percentile and median for each measure.    What I have created so far s a long table of repeated data.

 

I have tried looking into the Tile tool as an alternative but I got stuck on how to identify the values for the tile splits.

 

Many thanks in advance for any suggestions

 

 

 

 

Magnetar
Magnetar

Hi,

 

While I think this is theoretically possible with a macro, I think it gets pretty complex quickly and is somewhat brittle.


I've attached a workflow which I believe accomplishes everything you want without a macro.  It does this by using a few different cross tab functions to get each value, and then using some joins to bring the data together.

 

Hope this helps!

Labels