https://community.qlik.com/t5/App-Development/Reference-Line-on-Bar-Chart-Formula-Question/m-p/1613356#M45674 <P>Hi -&nbsp;</P><P>I have a Bar chart</P><P>X -Axis : Year/Month (from the field requesteddate)</P><P>Y-Axis : Count of Requests (from the field requests)</P><P>&nbsp;</P><P>I would like to show a reference line that displays the average count based upon the months selected.</P><P>How can this be accomplished ? Thoughts ? Jerry</P> Fri, 16 Aug 2019 15:28:18 GMT jerryr125 2019-08-16T15:28:18Z https://community.qlik.com/t5/App-Development/Reference-Line-on-Bar-Chart-Formula-Question/m-p/1613356#M45674 <P>Hi -&nbsp;</P><P>I have a Bar chart</P><P>X -Axis : Year/Month (from the field requesteddate)</P><P>Y-Axis : Count of Requests (from the field requests)</P><P>&nbsp;</P><P>I would like to show a reference line that displays the average count based upon the months selected.</P><P>How can this be accomplished ? Thoughts ? Jerry</P> Fri, 16 Aug 2019 15:28:18 GMT https://community.qlik.com/t5/App-Development/Reference-Line-on-Bar-Chart-Formula-Question/m-p/1613356#M45674 jerryr125 2019-08-16T15:28:18Z https://community.qlik.com/t5/App-Development/Reference-Line-on-Bar-Chart-Formula-Question/m-p/1613374#M45676 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/24530">@jerryr125</a>&nbsp;,</P><P>If you can show an example, but ... would be ...</P><P>Reference line expression:</P><P>&nbsp;</P><LI-CODE lang="markup">=count(requests)/count(distinct month)</LI-CODE><P>&nbsp;</P><P><span class="lia-unicode-emoji" title=":thinking_face:">🤔</span></P><P>Regards&nbsp;</P><P>Ezir</P> Fri, 16 Aug 2019 18:49:48 GMT https://community.qlik.com/t5/App-Development/Reference-Line-on-Bar-Chart-Formula-Question/m-p/1613374#M45676 Ezirraffner 2019-08-16T18:49:48Z