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

Ranking Formula Based on Concatenation

thenning
7 - Meteor

I'm currently working on a workflow in which I need to rank some rates from an input file based upon a concatenation of the Measure & State.  I want to classify the top 33% as "Best," the middle 34% as "Middle," and the bottom 33% as "Worst".  I've done a normal ranking formula before, but I'm having difficulty factoring in the concatenation as a variable.  Can anyone help me out?  I've attached a sample file that shows what I'm looking at and the desired output.  Any assistance would be greatly appreciated.

 

Sincerely,

T.H.

6 REPLIES 6
Claje
14 - Magnetar

Hi,

 

It's not exact to your expected results ( Client Name 7 is classed as "Middle" instead of "Bottom"), but take a look at the Tile Tool.  I configured it for Equal records, set it to create 3 tiles, and told it to sort by Rate and Group by Concatenation.

 

Take a look and let me know if this helps!  If you need the results to be split exactly how you did, you can likely replicate this functionality, although it will take some work.

JosephSerpis
17 - Castor
17 - Castor

Hi @thenning I mocked something up which I think answers your question. The output is slightly different from your desired output however I followed the logic you described. Let me know what you think?

thenning
7 - Meteor

@JosephSerpis,

 

I'm having issues opening your workflow.  I believe it's because my company is still using version 2018.4.  Any thoughts?

 

Thanks!

@thenning 

JosephSerpis
17 - Castor
17 - Castor

Hi @thenning I made it backwards compatible try this version. 

thenning
7 - Meteor

Thanks @JosephSerpis,

 

I can view it now.  One follow-up question:  Is there any way we can add another if/then statement to classify any rates that are equal to 0 as "N/A"?  I want only the rates with actual values to be ranked, if that makes sense.  Thoughts?

 

Sincerely,

TH

JosephSerpis
17 - Castor
17 - Castor

Hi @thenning The attached will now if rate = 0 then N/A in the rank field.

Labels