Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to group data by categories before analyzing it?

yuvalshmul
6 - Meteoroid

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!

3 REPLIES 3
Kenda
16 - Nebula
16 - Nebula

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
7 - Meteor

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
6 - Meteoroid

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

Labels