
1. Re: Hi, I am trying to create a scatterplot on Tableau... Any suggestions would be highly appreciated!
Dinesh Sundar Gomathinayagam Oct 5, 2016 2:40 PM (in response to Manasi Agarwal)1 of 1 people found this helpfulAs 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.

2. Re: Hi, I am trying to create a scatterplot on Tableau... Any suggestions would be highly appreciated!
Manasi Agarwal Oct 5, 2016 3:23 PM (in response to Dinesh Sundar Gomathinayagam)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!
Manasi Agarwal Oct 5, 2016 3:32 PM (in response to Dinesh Sundar Gomathinayagam)Does this look correct?
I converted both the variables into dimensions...
Kindly let me know if this makes sense!

revised view.tiff 273.0 KB


4. Re: Hi, I am trying to create a scatterplot on Tableau... Any suggestions would be highly appreciated!
Dinesh Sundar Gomathinayagam Oct 5, 2016 4:06 PM (in response to Manasi Agarwal)1 of 1 people found this helpfulThe 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 Yaxis against the dimension (independent variable) on the Xaxis.
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.