Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Creating a ranking

I'm having trouble creating a ranking system. I want to be able to rank each ID by the percentage of users reaching the last stage in the registration process. Basically, I want to be able to rank the last two columns (indiviudally but honestly a formula for 1 is sufficient) by highest percentage, by ID in the first column. 

 

BTW they are calculated fields.

 

Need Help

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Anonymous ,

    More details will be much helpful.

    If it is convenient, could you share some data sample which could reproduce your issue so that I could have a test on it?

    In addition, you'd better share your desired output based on your sample data so that I could understand your logic better.

    Best Regards,

    Cherry

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Basically, I want to rank the top 5 sub IDs and bottom 5 sub IDs each day. So I need a functional formula to rank these IDs on a date breakdown.

       

      I wank to rank based off of % Reg -> Fulfillment column percentages. The higher the percentage, the lower the rank