Reference Line on Bar Chart - Formula Question

[jerryr125]

Hi - 

I have a Bar chart

X -Axis : Year/Month (from the field requesteddate)

Y-Axis : Count of Requests (from the field requests)

I would like to show a reference line that displays the average count based upon the months selected.

How can this be accomplished ? Thoughts ? Jerry

[Ezirraffner]

Hi @jerryr125 ,

If you can show an example, but ... would be ...

Reference line expression:

=count(requests)/count(distinct month)

🤔

Regards 

Ezir