Axis Rank in Visual on Grouped Data

[Anonymous]

Hi there,

Is there a way to adjust axis rank to: Rank 1-2, Rank 2-6, Rank 6-10....

Tried to use Sort By but failed on either.

The Rank is from "Position" by using "IF(AND (>=1, <2), "Rank 1-2", IF(AND(>=2, <6), "Rank 2-6"......)

Thanks.

H

[Anonymous · Accepted solution]

Can I reply myself.....😅a little weird....

Resolved by creating a new table with Agg. Rank and Sort number (1,2,3,4,5).

Then create relationship between 2 columns.