Forum Discussion

dutchlimits's avatar
dutchlimits
Helper I
7 years ago
Solved

Total average over all dates

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? 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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.