Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Group by and take the top 10?

jeh
7 - Meteor

Im starting with UPC sales data.

 

The sales data has a column that can be grouped into parts of the store. Checkout, Candy Isle, Meat Snacks, Chips. 

 

Without having to do multiple summarize tools, sort, take top N. 

 

Is there 1 tool that allows you to group by a column and then take the top N of each of those groups? 

 

 

4 REPLIES 4
Claje
14 - Magnetar

Hi,

If your data is sorted, the Sample tool will do exactly this - you can set it to group by as many fields as you'd like!

afv2688
16 - Nebula
16 - Nebula

Hello @jeh ,

 

You could sort by a certain column and after use the sample tool. This will give you the top you are looking for. You could also transpose the data to make it easier (depending on how you have everything organized)

 

If you share a small sample of daya I might be able to build something.

 

Cheers

jeh
7 - Meteor
I feel dumb. I was working in a smaller window...... I see it. THANKS!!! @Claje @afv2688
afv2688
16 - Nebula
16 - Nebula

Hello @jeh ,

 

If we solved your doubts could you please do us the favour and mark it as solved?

 

It helps the community

 

Thank you

 

Cheers

Labels