Average a counted value

[Anonymous]

Hi, I have plotted a graph showing the count of calls for each hour over a couple of months. However I cannot igure out how to add the average for each hour and for this to adjust with the sliders selecting the time period.

Any help would be great please.

[Kishore_KVN]

You can achieve this in two ways:

1. Go to analytics and choose add a average line.

2. Change graph to Column and line chart, write down below measure 

      Average Calls = Average(Calls)

     then drag it in to the line value 

@Anonymous If this post helps, then please consider accepting it as the solution to help other members find it more quickly.THANK YOU!!

[Anonymous]

Thank you @Kishore_KVN but this doesn't seem to work, the average line is constant and the measure doesn't work.

This may be because the graph is counting the number of addressess to get the number of calls, so I need the averag eof a count of text values