4 Replies Latest reply on Oct 5, 2016 4:06 PM by Dinesh Sundar Gomathinayagam

Hi, I am trying to create a scatterplot on Tableau... Any suggestions would be highly appreciated!

I have a dataset for 10 years with 6 variables.

I need to see which pairs have a correlation... It may be a very simple task... but I am very new to Tableau!!

How can I do this?

I tried doing this with 2 variables, the snapshot I am getting is attached.

Regards

Manasi

• 1. Re: Hi, I am trying to create a scatterplot on Tableau... Any suggestions would be highly appreciated!

As all the data in your excel sheet are numbers tableau will initially load it as measures and when you try to plot it, you will end up with one dot at the sum of the two "measures". Try changing the measures to dimensions before plotting it.

Find attached the resulting plot. I hope this is what you were looking for.

1 of 1 people found this helpful
• 2. Re: Hi, I am trying to create a scatterplot on Tableau... Any suggestions would be highly appreciated!

Thank you! I guess that is the mistake I was making.

Just to clarify, (beginner's syndrome!), I have 3 variables- year, and 2 other variables for which I need to find the correlation. should I convert both to measures?

Is that correct?

Thank you so much for your help!!

Grateful indeed.

• 3. Re: Hi, I am trying to create a scatterplot on Tableau... Any suggestions would be highly appreciated!

Does this look correct?

I converted both the variables into dimensions...

Kindly let me know if this makes sense!

• 4. Re: Hi, I am trying to create a scatterplot on Tableau... Any suggestions would be highly appreciated!

The independent variable should be a dimension and the dependent variables should be measures. So you would be plotting the aggregate (sum, max, min, average, etc) of the measure (dependent variable) on the Y-axis against the dimension (independent variable) on the X-axis.

For future reference, it would not matter if you convert the dependent variable into dimensions if the independent variables are unique in the data source.

1 of 1 people found this helpful