Forum Discussion

xiumi_hou's avatar
xiumi_hou
Post Partisan
6 years ago

Why my rank function start from 2

Dear all, 

 

I have my rank measure:

rank=rankx(all(d_user[name]),[count_measure})

 

when I create a table, the first column is name, second column is rank, the rank order is correct, but it alwasy start from rank 2.. any suggestion? Thanks

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

     

    I am not very clear about your situation. Could you may be provide your sample data and the table you mentioned (rank start from 2)?

     

    It should be work properly with your measures, maybe you need to sorting the ranks manually. 

     

    Best,

    Paul

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • xiumi_hou's avatar
      xiumi_hou
      Post Partisan
      6 years ago

      Update, acutally, I do not have rank 1, my rank start from rank 2.... Actually the rank 2 should be rank 1 and rank 10 should be rank 9 in my ranking function. Thanks.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        xiumi_hou 

        I see your problem clearly now, but could you provide some data and the formula you used so I can help you to figure out what is going wrong.

        Best, 
        Paul