In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Rank Tool (New Tool)

Status: Implemented Submitted by on ‎04-12-2016 01:17 PM
18 Comments (18 New)

The introduction fo a rank tool would be hugely beneficial. Whilst there are currently means to rank using a combination of other tools formula/running total/multirow etc... a specific "Rank Tool" would be provide a seemless and smoother way to rank your data either for further analysis or purely to output this field.

 

This tool should include a sort by and group by functionaility as well as options for ranking (such as dense ranking or unique ranking) and in addition multi levels of ranking (ie. Rank by "Field A" Then By "Field B" etc...).

See more ideas labeled with:
18 Comments
Haroonanalytics
7 - Meteor
‎09-17-2020 06:32 AM

100% agree. Just came across a ranking issue in Tableau and thought ranking in Alteryx would've been a quick solution - especially when you are reverse ranking 4 different fields - but it isn't.

 

I've got to my solution eventually but having a tool that ranks the fields vertically and also allows reverse ranking option would massively help.

 

 

0 Likes
Salvatore_Miseo
7 - Meteor
‎02-12-2021 09:57 AM

I fully agree, especially in the light of other less sophisticated programs, such as excel, which have already had this type of function for years.

0 Likes
shreya_25
5 - Atom
‎06-02-2021 03:53 AM

Hi Everyone, I might be missing the point here, but can the Running Total tool be used to rank data?

 

Appreciate your thoughts on this!

0 Likes
CristonS
Alteryx Alumni (Retired)
‎11-09-2021 03:38 PM
Status changed to: Not Planned
 
0 Likes
mbailly
5 - Atom
‎11-15-2021 12:48 PM

Capture.JPGIt's really disappointing that this is now Not Planned. I can use a fairly easy Excel formula to rank given specific criteria. It takes about 6 tools to get a proper rank in Alteryx, and that doesn't include having to split sub-groups before ranking too.

 

0 Likes
NicoleJ
Alteryx
Alteryx
‎10-03-2024 12:31 PM
Status changed to: Coming Soon

We've revisited this one, and good news - coming soon! :) Stay tuned for updates on a new Rank tool coming to a Designer near you...

0 Likes
nbondarchuk
Alteryx
Alteryx
‎10-31-2024 03:15 AM

New Rank tool is available in Designer starting from 2024.2, October 30, 2024

Rank tool is available via the AMP engine only. Go to Rank Tool for details and configuration information.

0 Likes
NicoleJ
Alteryx
Alteryx
‎11-07-2024 05:52 PM
Status changed to: Implemented

New tool alert!! Check out the Rank tool, added in 24.2 release - includes several ranking types and the ability to choose your rank column(s), sort order, and group by options!

0 Likes
Labels