Desired Outcome:
Shows only the top 5% of people who have spent more than 10000
Table Output - Just the User ID and the amount
Current Outcome:
Shows everyone who has spent more than 10k
Information:
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.
... View more