I need to calculate the percentile from a non-numeric field. I have an index to represent all events, include the user. The objective is to calculate the percentile based on events forms users (count of user field).
user | metric count
A | 98
B | 93
C | 88
D | 73
(...)
Example: percentile 90th = 90 -> filter users have count above this value. It's possible?
TY