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

# Combining two graphs

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).

Dimension = Month

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

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?

• ###### Re: Combining two graphs

Use combo chart...

• ###### Re: Combining two graphs

Combining the types of graphs isn't my problem, combining the two different dimensions of the graphs (month, and Year & Month) is my problem.

• ###### Re: Re: Combining two graphs

The excel in the attachment.

• ###### Re: Re: Re: Combining two graphs

Hi Willem,

I attached a working solution, where I pre-calculated the average in the script. There is one issue however - I needed to reduce number dimensions to only one as there seems to be an issues with line graphs and two dimensions;

If I use two dimensions, Year first, this is the result:

I have noticed previously that lines in combination with several dimensions behave very strangely. Even stranger is that two dimensions work if I swap the Year and Month dimension:

/Christian

• ###### Re: Combining two graphs

Thanks Christian. Looks allright! I'm going to have a go at this.

I, too, noticed the strange behaviour of the two dimensions. Should we report this?