2 Replies Latest reply on Nov 28, 2018 10:41 AM by Yinglu Wang

    Rank based on calculated field (has duplicates)?

    Yinglu Wang

      Hi everyone,


      I have a question about Rank. Is there a way to start ranking based on the values from another calculated field?


      I have a calculated field as below:

      Screen Shot 2018-11-28 at 13.10.16.png


      I want to have another column called Rank, it should be 1 when cond="start", and the number should be incremental till cond="end".


      The result should look like this:

      Screen Shot 2018-11-28 at 13.19.52.png


      Any insight will be helpful!