Hi All,
I'm using below script in bar chart as a reference line.
I first get the interval of two dates ex:(End Date - Start Date)
then
if Start Date is greater than End Date then show as '0'.
then Aggr and Avg .
=Avg(Aggr(if(
sum(12 * (Year([Valid Date]) - Year([Submission Date])) + Month([Valid Date]) - Month([Submission Date]))>0,
sum(12 * (Year([Valid Date]) - Year([Submission Date])) + Month([Valid Date]) - Month([Submission Date])),0)
,ProductName,Country))