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

Total Posts

1.0K

Likes

485

Correct Answer

250

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

485

Correct Answer

250
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

Total Posts

1.0K

Likes

485

Correct Answer

250

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

485

Correct Answer

250
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?