Variable reference line - not a fixed reference line

[Seb2588]

Hi everyone,

I have the following graphic and i would like to add a reference line that calculates depending on the X-axis and the second dimensions, see bellow

The gray line is a reference line (i drew it) that shows the average of all the second dimension data , and is the average per of every month in the  X-axis.

[chris_djih]

You may don't look for a "reference line" since reference lines are for orientation in the diagramm and will allways be a straight line.
What you're looking for is as you already mentioned an average line. Which could be done in a combo-chart.
So big challenge is now to finde the correct expression for this.
Try to change your title, so you may get better help.

[Seb2588]

Thanks for your answer, the thing is, if i use a combo chart i wont be able to have 2 dimensions, Month and Farms.

That is why i'm exploring the reference line option.