Rank Function Problem

[haneeshmarella]

Associate	Avg. Picks	Rank
A	12	1
B	15	1
C	79	1

Hi guys,

I try using the rank() function to rank associates based on avg. picks but it does not work, it gives me the same rank for everyone. What am I doing wrong?

I used rank([Avg. Picks]) and it gives me all 1's.

I used the same way in another dashboard, and it works perfectly fine. No idea why this isn't though.

Thanks in advance!

[rubenmarin · Accepted solution]

Hi, it looks like you are using Avg.Picks as dimension, leave Associate a the only dimension and set avg. Picks as an expression. Rank should work as you expect.

If you need Avg. Picks as a dimension you can try with "Rank(TOTAL [Avg. Picks])"