6 Replies Latest reply: Nov 8, 2015 7:19 AM by Massimo Grossi RSS

    Normalising Data

    G Bortz

      I am trying to normalize a time series relative to say the peak value of the stream, or even to the first value :

       

      I have say a time series of values , with their day number and their month ( 92 days over 3 months  ie august to October). I tried to use set analysis to fix say the peak value in September. ie Max_Value = Max({< Month = {"September"} >} Timeseries). I then tried to use a bar graph where the expression is Timeseries / Max_Value. This gives a series of ones ie the expression keeps normalizing the values over the value itself ..it does not keep the Max value according to the September Maximum.  How do you therefore Normalize the stream over a desired value ie a preferred Month's maximum value. I am probably using misusing set analysis here?


      Thanks

      G.