Shows only the top 5% of people who have spent more than 10000
Table Output - Just the User ID and the amount
Shows everyone who has spent more than 10k
This is my latest try, but it is ignoring my perc5 part (I tried 95 as well, same result)
|stats sum(actual_cost) as Spent by user_account_id | where Spent > 10000 | stats perc5(Spent) by user_account_id
I've been scouring the Internet and trying five million things and can't get this to work as it just keeps showing everyone.