I'm creating a trellis line chart which a tracks a value year over month. I'd like to add a line indicating the average value per year to each section of the trellis chart. I've tried following this solution:
I've attached a small application as an example. I can calculate the correct yearly average, however I'm not able to extend that value to all months in the given year. I would like my chart to look like the below image.
Thanks for the suggestions Robin. Is there any way to calculate the averages without changing the script? I was hoping this could be done by writing an expression.
I don't think that it is possible without changing the script because the values just don't exist for 2014...
(could be that I am wrong )
For this chart type there's no "populate missing" option as it exists for pivot charts.