Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to calculate the correlation between two dataset. How can I use a set analysis in the correl expression. This is what I tried, but that doesn't work:
Correl(avg({$< Variable = {"P02.01"}>}TOTAL #score),avg({$< Variable = {"P03.01"}>}TOTAL #score))
Who can help?
The Correl() function should operate on pairs of dimensional data values, not on a pair of scalar values.
I think you would need to apply advanced aggregation, something like
Correl(
Aggr( avg({$< Variable = {"P02.01"}>}#score), Dimension) ,Aggr(avg({$< Variable = {"P03.01"}>}#score), Dimension)
)