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.
Give this a try
|stats sum(actual_cost) as Spent by user_account_id | where Spent > 10000 | eventstats perc5(Spent) as filter | where Spend>=filter
View solution in original post
That totally did it, now just to hide the "filter" column, but that's not that big a deal and the underlying issue is now resolved.