Hello,

I have created to line charts showing what is coming in and the other showing what is going out. I have two different date fields for these but I have synchronized it into one chart. I am trying to add a reference line which will give me an average for the measure for the two date fields. I will also like to add a historical average which also be dynamic to any filter when I used it on a dashboard. For example, I will like to see two average lines for the current year and two average lines for the previous year.

I know this is confusing but I have attached a sheet that shows what I am trying to do.

Thank you.