
1. Re: Correlation Matrix of All Measure
Yuriy Fal Nov 27, 2018 2:01 AM (in response to Usman Tariq)Hi Usman,
In Tableau the CORR() is an aggregate function
(and the WINDOW_CORR() is her Table Calc cousin),
which takes the two vectors as an input
and produce a single vector as an output
(and using only the Pearson to calculate).
Hope it helps understanding.
Yours,
Yuri

2. Re: Correlation Matrix of All Measure
Usman Tariq Nov 27, 2018 2:58 AM (in response to Yuriy Fal)Hi, Yuri
Thanks for the reply. But I wanted to ask is it not possible if I could somehow do it in the Calculated field. Since it does not support any kind of loop so is there any other alternative way? In which I could calculate the correlation of one Measure with all other Measure?

3. Re: Correlation Matrix of All Measure
Yuriy Fal Nov 27, 2018 4:00 AM (in response to Usman Tariq)Hi Usman,
You're right, there's no looping calc logic in Tableau,
so one outta brute force via some data transformations.
I could imagine the UnPivot of all Measures
into the two columns (Names & Values),
then do SelfJoin ON the [Row ID] column
(you have to have one in the datasource)
to get all Measures combinations.
Then a matrix view would be just a click away.
Yours,
Yuri