Creating buckets of percentile

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Urs_Boller

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?

Urs_BollerAccepted solution

New Participant

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?

New Participant

can we do based on all orders counted together ?

New Participant

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

Sign up