Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Creating buckets of percentile

Avatar

Level 1

Hi I am trying to create groups of users such that they fit into one of the 4 groups below:

0 -25th percentile

26th - 50th percentile

51 -75th percentile

76th - 100th percentile

based on amount of money they have spent. I tried both percentile and quartile functions but they dont seem to work correctly.

3 Replies

Avatar

Community Advisor

how do you create the segment/function so far? is the "amount" based on a single order or more orders counted together?

Avatar

Level 4

can we do based on all orders counted together ?

Avatar

Community Advisor

after think about the question I don't believe you can use the calculated metrics (they can't be used within a segment).

maybe you can try the Histogram or Scatterplot  with calc. metric "revenue per visitor" and "unique visitors" to see some patterns?