Total average over all dates

[dutchlimits]

Hi guys,

Got a (i hope) simple question.

I cannot figure it out. I need the red line to be the average over the entire table. Right now it shows the average per month, but it needs to calculate all the dark columns and show the average in a straight line like the black line below: 

So it should count up all the dark values, and divide it by the number of selected months/days

Anyone got a trick for this? 

[Anonymous · Accepted solution]

If you select your visual, then the analytics icon (magnifying glass) over in the visualisations pane you should then have a number of options including "Average Line" you can then add one or more lines and dictate which measure these are applied to. Hope this helps.

[dutchlimits]

Edit

That worked, thanks!