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

Percentrank Function

djoyus1
8 - Asteroid

A colleague is trying to replicate the Excel PERCENTRANK function: https://support.office.com/en-us/article/percentrank-function-f1b5836c-9619-4847-9fc9-080ec9024442

Capture.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I've included the dataset on which he wants this applied.  What's the best set of tools to tackle this given the volume and numeric type?  I've seen other rank solutions as there's no grouping involved and they don't address his desired outcome. Any direction is appreciated!

2 REPLIES 2
BenMoss
ACE Emeritus
ACE Emeritus

I've taken the logic outlined here: http://www.real-statistics.com/descriptive-statistics/ranking-function-excel/ and applied it in Alteryx.

 

I've created two example streams, one where I want the % rank across the entire data stream, and one where I have a grouping field.

 

Does this suit you need?

 

Ben

djoyus1
8 - Asteroid

@BenMoss - Thanks, but when I compared to the Excel results the output wasn't the same.  

 

I've attached my solution - it's not the prettiest but it works.

Labels