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