Hi,
I'm new to Splunk and I'm quite stuck on how to group users by percentile.
Each user has the option of paying for services and I want to group these users by their payment percentile. So if the max anyone has cumulatively paid is $100, they would show up in the 99th percentile while the 50th percentile would be someone who paid $50 or more. Based on that grouping I want to know the average number of sessions they've logged in my app.
It'd look something like this:
Percentile
Avg Payment
Sessions
99%
99
50
80%
82
44
50%
60
25
0%
0
60
I would be grateful for any help on how to achieve this. Thanks!
... View more