3 Replies Latest reply on Sep 3, 2018 4:15 PM by Ritesh Bisht

    Changing the scale

    Lars Borgmann

      Hi everyone,


      I'm stuck with a problem and need help.


      I have as input two variable, themes and the search volume to the theme.

      The data looks like this:


      Screen Shot 2018-08-16 at 20.59.15.png


      I want to convert the data now so that the highest value per topic gets the value 100 and the lowest value gets the 0.


      So I would like to apply the following formula per topic:


      (Volume - Min(Volume))/((Max(Volume)-Min(Volume))


      Unfortunately it doesn´t work or I don´t find the right solution -  any help is more than welcome


      Thank you in advance,