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,

       

      Lars