Hello,
I am having trouble figuring out how to use denseRank.
I would like to rank the “Seller” in each “Region” by their “Total” number of sales. When I use Rank or denseRank all the ranks come back as 1. What am I doing wrong?
Please see the Arena dashboard as an example. denseRank_question
Hi @maraujo,
You’re currently ranking every seller against themselves - that’s why the value is 1.
If you remove “Seller” from your partition, it should give you the correct result.
denseRank([sum(Total)DESC],[Region],POST_AGG_FILTER)
Thank you so much! This worked!!