6 Replies Latest reply: Jun 20, 2016 5:31 AM by JAVIER ARTIEDS RSS

    How to normalize data in a graph

    JAVIER ARTIEDS

      Hello all,

       

      I have 3 columns of data: Fundname, date and value. The user can select the initial and final dates of the graph which are stored in the variables InitialDate and FinalDate. I would like to show the value of each fund so that in the InitialDate its value was 100, but I am unable to do that. By the moment I have this in the expression:

       

      value*100*if(date>=InitialDate,1,0)*if(date<=Finaldate,1,0)/( {<date={'$(InitialDate)'}>}value)

       

      And as dimensions of the line chart Date and Fundname.

       

      Anyone could help?

       

      Thanks a lot!