How to group data by categories before analyzing it?

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!

Example Workflow.yxmd

Datasets

Accepted answers

jgv27

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.

Example Workflow.yxmd

All comments

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/ta-p/488165

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

jgv27

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.

Example Workflow.yxmd

yuvalshmul

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703