Thanks for replaying Zhouyi, is it possible to create the view(like staircase) similar to what I had mention in my question. I was following some article to accomplish it but did not get the exact solution. And if you don't mind could you please explain what join condition 1=1 will do.
If we could achieve the correlation matrix using single data source without duplicating the data source, It would be great to know that.
thank you so much for your response.
Thank you Zhouyi it helps me to get my desired results. I have added the condition which you have mentioned in the screenshot, in my existing calculated fields.
Just one question, I have to create the charts for all the variables present in my worksheet for example Rbc which is a string type and we can not apply corr() function on it so is there any workaround you would suggest to achieve it.
once again Thank you,
You can convert string to integer/float using int/float function and use that calculated field in Corr function
Hi Ombir, The Rbc field actually have the string values. So my question is how could I use the corr() function for Rbc dimension.
Thanks for your response.
Corr function in tableau only works for continuous variables. However, you can convert string to integer values by mapping dimension members to numbers like High=1, Medium=2, Low=3 etc.
If you're familiar with R/Python then it would be easy with SCRIPT functions in Tableau to check correlation between categorical variables.
Hi Ombir, Thanks a lot for your time and response. I have multiple fields around 14 which has the string values and i need to create the single correlation matrix for all of them. If R would give a better option within a tableau I would be happy to explore more on this.
This thread is closed so I have created another thread which I had opened for creating a single correlation matrix for all the variables.
Request you to please respond on above thread. I would be waiting for your response, if you have any suggestion.
Thank you Ombir.