-
1. Re: Remove overlapping from Scatter plot graph
V MaharajhJul 5, 2019 3:09 PM (in response to Carlos Carvalhar)
-
2. Re: Remove overlapping from Scatter plot graph
Carlos Carvalhar Jul 6, 2019 12:23 AM (in response to V Maharajh)1 of 1 people found this helpfulI don't want to resize it, i'd like to show each one of the overlapping points.
Mainly because I'd like to add all labels, from every point.
This tutorial has something using jitter Jitter those points! but i couldn't replicate the effect with random points distributed trough the center.
-
3. Re: Remove overlapping from Scatter plot graph
Paul WachtlerJul 5, 2019 7:23 PM (in response to Carlos Carvalhar)
Hi Carlos,
There are currently 42 rows that have values of 5, 5. If you want to jitter them, or separate them, you need to either add to them or subtract from them so they're not all on the same point.
If you change the axes from integers to decimals, you can change the 5 to 5.1 or 5.2 and jitter them a little. You're still going to have overlap though because there are so many measures on that same point.
Best,
Paul
-
4. Re: Remove overlapping from Scatter plot graph
Carlos Carvalhar Jul 7, 2019 2:45 AM (in response to Paul Wachtler)1 of 1 people found this helpfulIs it possible to create a function in Tableau to calculate this variation?
I mean, filter those 42 and then changing a litlte the X,y coordinates?
-
5. Re: Remove overlapping from Scatter plot graph
Jonathan DrummeyJul 8, 2019 3:38 PM (in response to Carlos Carvalhar)
Hi Carlos,
It is possible to jitter these using some custom table calculations. However, I don't think jittering is the way to go for this particular view. The reason why is that on the chart as laid out depending on the screen size the available space (i.e. between 4 and 6 on the Y axis and between 4 and 6 on the X axis) is somewhere between 1-3cm on each axis. That's just too little space to put 42 distinct labels in any sort of reasonable font size. What is the purpose of trying to show all the labels? Also is this a static output or an interactive visualization? For example in the latter case a separate view might be used to show the detail of those 42 values.
Jonathan
-
6. Re: Remove overlapping from Scatter plot graph
Carlos Carvalhar Jul 9, 2019 5:32 AM (in response to Jonathan Drummey)Yeah, i gave up about all labels.
Using rand() on excel i added some fractions at the end, so i could see the points a little distant from each one.
-
7. Re: Remove overlapping from Scatter plot graph
Vikram GokhaleJul 9, 2019 6:06 AM (in response to Carlos Carvalhar)
-
8. Re: Remove overlapping from Scatter plot graph
Carlos Carvalhar Jul 9, 2019 2:32 PM (in response to Vikram Gokhale)It's really interesting for web content, but in my case it's print and it would lose the effect.