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

Filter by Top 5 And Least 5 Performers

DataPirate26
10 - Fireball

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
20 - Arcturus
20 - Arcturus

@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
10 - Fireball

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

Qiu
20 - Arcturus
20 - Arcturus

@DataPirate26 
Thank you 

Labels