4 Replies Latest reply on Jun 26, 2018 12:27 AM by Alexander Hessler

    Rank by measure without viz

    Alexander Hessler

      Hi,

       

      I am trying to calculate a rank that works without a viz.

       

      my dataset look like that (but way larger):

       

      Product ID     Price

      1                    45€

      2                    50€

      3                    30€

      4                    20€

      5                    60€

       

       

      I need a calculated field so that each product has its own value. In the dataset above it would look like this:

       

      Product ID     Price     Rank

      1                    45€          3

      2                    50€          2

      3                    30€          4

      4                    20€          5

      5                    60€          1

       

      I need them without viz because I only need the rank to run further calcs with it.

       

      I would truuuuuly appreciate your advice!


      Alex