Alteryx Designer Discussions

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

Calculate Decile (Distribution of Data)

Tommy23
7 - Meteor

Hello,

 

I will like to calculate the decile (1,2,3,....10) for  this list of data 100 rows , I know that I need to order the value then process the formula ((100+1)* n  /  10)  where n represent the decile ( 1, 2, 3,....10).

 

After finding the rank for example the first decile will be "10.1"  I need to go check the value of the 10 and 11 rank ( because 10.1 is a double) and process this formula  :   "value of rank 10" + 0,1 * ("value of 11" -  "value of rank 10") =  value of decile 1

 

How to implement this formula and calculate all decile value from 1 to 10

 

I upload a sample data of the 100 rows

 

Thanks in advance for your help

1 REPLY 1
ncrlelia
11 - Bolide

Hi @Tommy23 

 

Please find attached my suggestion.

Hope it helps.

 

 

Best Regards,

Lelia

Labels