Select top 5 only

[JPCSC]

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

[dougperez · Accepted solution]

Use sort and sample

[atcodedog05 · Accepted solution]

Hi @JPCSC 

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

Hope this helps : )

[Tyro_abc]

Hi 

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

Best Regards

Arundhuti

[Garabujo7]

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.

Just like in the sample tool example: