Dynamic Reference Line in a scatter chart based on a variable

[ficheral]

Hello community,

I am facing a visualization problem. 

I want to create a scatter chart where I have a measure 1 ( a variable aggregating a measure in a table) in the x axes and a measure 2 (a variable aggregating a measure in a table) in the y axes.

I want to show a reference line in the Y  axes (in brown in the picture) being the average of measure 2 dynamically changing according the filtering in the dimension of the cycle group.

Further I want to show  a reference line in the X axes (in red in the picture) being being the average of measure 1 dynamically changing according the filtering in the dimension of the cycle group. 

I suspect that I could make use of AGGR function (since measure 1 and measure 2 are already aggregated variables) but cannot get the syntax right.

Can someone help me?

[chrismarlow]

Hi,

I think you are going to need to share more about the set up of your measures & your cyclical group/dimension, as I am guessing you have got to the point of enabling the reference lines?

Cheers,

Chris.