How to use count distinct
When I do count(distinct) it is saying that is not a valid formula. Below is my formula. I am counting the sales names named (SalesHost), but against their sales and I want to sum the sales. I added a beastmode to calculate the rank, but need to get rid of the duplicate sales names. The first is invalid, but the second is not and the second wont allow aggregation.
count(distinct `SalesHost`) over (order by `NetSales` desc)
count(`SalesHost`) over (order by `NetSales` desc)