7 Replies Latest reply: Feb 18, 2014 5:39 AM by Christian Lauritzen RSS

    Combining two graphs

    willem timmers

      Hi,

       

      Basically I want to combine the following two graphs, in the way that the average values are in the background of the time series' absolute values (that the absolute value of a month can easily be compared to its historical average, so graph 1 is repeated 6 times in the background of graph 2).

       

      1.png

      Dimension = Month

      Expression =Avg({1}$(Heat))


      2.png

      First dimension = Year

      Second dimension = Month

      Expression = Heat

       

      I tried set analisys and TOTAL, but i couldn't figure it out. Is there a way?