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.
can we do based on all orders counted together ?
how do you create the segment/function so far? is the "amount" based on a single order or more orders counted together?