Segment customers by percentile of total revenue

[TigerCole]

I need to be able to segment a dataset that lists all customers and their total annual revenue. I need to be able to segment them into the top 1%, 2%, 3%, 5%, 10%, …, 90%

I tried using the Auto-Binner node. I selected the total revenue column and set the sample quantiles to 0,0.01,0.02,0.03,0.05,0.1,…,0.9.

Is this the correct way to do this? … or is there a better way to get a reliable result. The results seem off.

Thanks,

tC/.

[ipazin]

Hi there @TigerCole,

would say yes but judging from node description to get top 1% you need 0.99 percentile and not 0.01 which will give you the bottom 1%.

“The smallest element corresponds to a probability of 0 and the largest do probability of 1.”

Br,
Ivan