How to calculate average line in line chart

[rupaliqlik]

Hi Folks,

In my dashboard I have one line chart where I am showing Target Volume and Actual volume .User asked me to make new average line chart for the Actual Volume .

Jan 391732+
Feb 370586+
Mar 250750
Total Of the Actual for all 3 month=10,13,068
No of month=3

Average line =3,37,689.33

Month can be vary so how to achieve above.

@abhijitnalekar 

[rubenmarin]

Hi, you can try adding a reference line, in the add-ons sections of the object property.

the expression for the reference line can be:

([ExpressionForActualVolume])/Count(Distinct MonthFieldName)

[abhijitnalekar]

Agree with @rubenmarin .