1 of 1 people found this helpful
I think the terminology of using a scatter plot in context to what you are looking for is not what you want. Scatter plot is a correlation of 2 variables on X and Y axes for a set of values and how they correlate.
You can pretty much drag customer on columns, values on rows and date (exact) on color and change the mark type to 'circle' on the marks card and you should have what you want.
Is there any way to plot a dot for the average of the dots for each column? e.g. I played around a bit with this plot and generated the plot below. For confidentiality reasons, I had to black out the labels for X axis. I ended up generating two charts when I dragged the Invoice measure twice--once using sum and the using average. Ideally, I would like to draw a candlestick-like chart that show a straight line connecting all the dots for each of the column variable and then plotting a dot in different color for average of those values.
While dragging another instance of the invoice pill make sure there is nothing on level of detail of the 2nd marks card. You can do something like this maybe: Drag min(number of records) on columns and change the mark type of the sum(value) to line to have the line pass through the 3 dots. And change the mark type to circle for the 2nd axis avg(value):
So basically the average of the 3 dots for customer B is 12,333.3
I did that and now I am able to get a plot structure that I want; however, having dual axis gives me my average values that are outside the range of my actual values. I noticed the axis range for the second one is different, so I synchronized it and now I get all the average dots on the Yaxis zero line.
How can I fix that?
Secondly, I do not want the number or records labels visible on X axis. Instead I want the actual X axis variable that is now visible on the top of the chart to be visible on the actual X axis below the chart.
Note I have used here the sample Global superstore database that comes with Tableau examples. (attached here)
Global Superstore.xls 17.4 MB