Forum Discussion
Scatter Plot Average Line
Looking at your chart, it seems odd that your X-axis is a count of UIDs. It seems that how many UID's a certain product category has isn't a useful way to group or plot them. However, it seems your problem resides in how simple and uncustomizable the Data Analytics lines are for scatterplots.
I've done some reasearch, and playing around with your example file, and as far as I can tell, there's no way accomplish this with a scatterplot, unless you make a custom visual. I even played around with some of the scatterplots on the marketplace, and none of them seemed to be able to accomplish this either.
My solution would be to use a different visual. I'd set this up as a bar and line chart. Then you can set up a measure or your average column as the line value, and set the category types as the X-Axis.
Looking at your chart, it seems odd that your X-axis is a count of UIDs. It seems that how many UID's a certain product category has isn't a useful way to group or plot them. However, it seems your problem resides in how simple and uncustomizable the Data Analytics lines are for scatterplots.
I've done some reasearch, and playing around with your example file, and as far as I can tell, there's no way accomplish this with a scatterplot, unless you make a custom visual. I even played around with some of the scatterplots on the marketplace, and none of them seemed to be able to accomplish this either.
My solution would be to use a different visual. I'd set this up as a bar and line chart. Then you can set up a measure or your average column as the line value, and set the category types as the X-Axis.
