Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Axis Rank in Visual on Grouped Data

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

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.