Issue with Rank() function

[andrespa]

Hi, I'm facing and issue that I'm not able to understand. I'm using the Rank() function in both a table and a bar chart. Same dimension and same metric but I'm getting different results. See the images below:

Did Someone have faced something similar? Any help will be appreciate it.

Cheers,

Andrés

[kaushiknsolanki]

HI,

Is it possible to share some sample data which can show the issue which you are facing.

Regards,

Kaushik Solanki

[MK_QSL]

Try

Rank(SUM([Actual Revenue]))

[Anonymous]

Hi Andres,

Try this expression in the chart:

Rank(sum([Actual revenue]),1,2)

and also sort it by

Rank(sum([Actual revenue]),1,2)

It should work.

[viveksingh]

Can you share sample app ?

[andrespa]

It doesn't. But in fact, the issue seems to be related to the sorting because with the same sorting it shows something different in table and in chart. What I can't figure out yet is how on earth is sorting.

[andrespa · Accepted solution]

Solved. It was an issue of the loaded data source. We detected some xls that random generated numbers, so each time the dashboard was loaded the numbers were different.

Thanks everyone for your help.

Cheers.