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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

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