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

Select top 5 only

JPCSC
5 - Atom

Hello Everyone,

 

I am working on Alteryx example and I am stuck on a step where I only have to select top 5 on Transactions per week. I tried sort and select but no luck.

 

Please see below the example and help me show a solution where I can only select top 5 transactions per week.

 

Thanks

JPCSC_0-1631121262466.png

 

4 REPLIES 4
dougperez
12 - Quasar

Use sort and sample

dougperez_0-1631121565345.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @JPCSC 

 

You can use sample tool and keep only first 5 rows for each week.

 

atcodedog05_0-1631121654812.png

 

Hope this helps : )

 

Tyro_abc
11 - Bolide

Hi 

You can use 'sort' followed by 'sample' tool

Tyro_abc_0-1631121767269.png

 

Best Regards

Arundhuti

Garabujo7
Alteryx
Alteryx

Hello @JPCSC , for that you could use the sample tool to get the top 5 and select the group by field, that in your case would be week thus will give you the top 5 per week.

 

Garabujo7_0-1631121830998.png

 

Just like in the sample tool example:

 

Garabujo7_1-1631121870814.png

 

 

 

Labels