Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
Agree with @rubenmarin .