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
BedrockMission!

Learn more

View all

Sign in to view all badges

Creating buckets of percentile

moa83214703
Level 1
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
ursboller
Community Advisor
Community Advisor

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

surajp86368405
Level 4
Level 4

can we do based on all orders counted together ?

ursboller
Community Advisor
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?