denseRank across two columns (dimensions) returning 1s


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.

1 Like

Thank you so much! This worked!!