I'd like to calculate the correlation coefficient of two variables when their value is calculated at an aggregated by "Gorup Name" .I have tried the following expression however I get all nul values. I have tried using the Group Name as a dimension too and also tried removing it. I know the variables themselves do work as I am plotting them on a scatter chart and I can see valid values. Ultimately, I want a single number to tell me what the correlation coefficient is for the two variables that can be seen in the scatter graph.
