15 Replies Latest reply: Oct 2, 2015 5:05 PM by Bhushan Nirgude RSS

    How to scale all expressions into 1 to 10 scale on Y - axis

    Bhushan Nirgude

      Hi All ,

       

      I have this bit different requirement from my client :

      I am calculating monthwise Sales , Qty , Avg bill Value , Avg product per bill and showing it as a line chart separately .

       

      Now client's requirement is to see all in one chart and that to on scale of 1 to 10 .

      In simple way minimum of all expressions (i.e. sales , Qty , Avg bill value, Avg products per bill)  has to be considered 1 , while maximum of all expressions has to be considered 10 . Now all values of all expressions lies between 1 to 10 & then it needs to show case as a line chart .

       

      Looking for help here ASAP .

       

      Thanks