How to group data by categories before analyzing it?

[yuvalshmul]

Hello,

I have a set of data that has ~24 categories. I want to filter for the top and bottom quartile in each category (based on the column "value")

I have done so for one category in the attached workflow, but it would be inefficient to repeat this flow 24 times for each category... how can I avoid doing so?

(note - this is fake data, the real data is actually thousands of rows long!)

Thank you so much in advance!

[Kenda]

Hi @yuvalshmul 

You could put this into a batch macro where the category is the control parameter. 

If you have never created a batch macro, here are some articles that may help:

 - https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/t... 

 - https://community.alteryx.com/t5/Interactive-Lessons/Creating-a-Batch-Macro/ta-p/657923 

[jgv27 · Accepted solution]

Hi @yuvalshmul and @Kenda 

I've also had a quick look at the question, and was wondering if a basic workflow utilizing the summarize tool for the top and bottom quartiles would also work?

Attached is an example of my thought process.

Let me know if this is similar to what you had in mind and if something like this would work.

[yuvalshmul]

Hi jgv27, yes, I think this will work perfectly! Thank you so much!