Calculate percentile from recency in MySQL. E.g, to rank customers based on recency of purchases or orders
It can be a pain to calculate percentile in MySQL. There are no functions for it yet. Here’s a ready made query to do it.
Calculate percentile from frequency or counts in MySQL. E.g, to rank customers based on number of purchases or orders instead of total sales