Creating buckets of percentile

Avatar

Avatar

moa83214703

Avatar

moa83214703

moa83214703

21-10-2019

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.

Accepted Solutions (0)

Answers (3)

Answers (3)

Avatar

Avatar

ursboller

MVP

Avatar

ursboller

MVP

ursboller
MVP

23-10-2019

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?

Avatar

Avatar

surajp86368405

Avatar

surajp86368405

surajp86368405

23-10-2019

can we do based on all orders counted together ?

Avatar

Avatar

ursboller

MVP

Avatar

ursboller

MVP

ursboller
MVP

22-10-2019

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