Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

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

Filter by Top 5 And Least 5 Performers

DataPirate26
9 - Comet

Hi,

 

Below I have shared a dataset from where I need to Filter out the Top 5 or top 10 or top 15 etc and the Least 5,10,15 .... performers based on the Integration percentage. 

 

The Selection category should be dynamic that is it can be top 5, top 10, top 12 , top 13, top 15 as required by the user. Same for the least performers. Also need top place them in 2 separate tables and union them by and write the output in the same tab. 

 

below attached is the given Sample Input Data and the Desired output. Can someone help with this. 

3 REPLIES 3
Qiu
19 - Altair
19 - Altair

@DataPirate26 
I use the Analytic App to allow to select the number. and hope you will not be to particular with the output format. 😁

0922-DataPirate26.PNG

DataPirate26
9 - Comet

@Qiu perfect. thanx a lot for your quick response.

Qiu
19 - Altair
19 - Altair

@DataPirate26 
Thank you 

Labels