Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Curious_George
Contributor
Contributor

scatterplot

when i select scatterplot for my sheet, then select two numeric fields into the "X" and "Y", the program makes me choose an summary statistic (count, average, sum, ..). But I don't want any summarization -- just a scatterplot of the raw data X and Y.  Can't figure this out.  Can anyone help out?

Thanks!

Labels (2)
2 Replies
justISO
Specialist
Specialist

Hi, when you building your scatterplot chart, at first for X and Y measures choose any aggregation to get aggregated, but working chart. Now in X and Y measures expressions manually delete these aggregations and just leave your X and Y. In this way you will get not aggregated plot as you wish. But there is one problem - if your dimension is not unique for all rows, lets say 'product' DD has 2 rows with different X and Y, you will see none 'bubbles' here, not 2 'bubbles' as, I believe, you wish to see. Just because you not aggregating them. If your dimension is unique for each row X and Y, there should be no problem, otherwise you need to make your unique dimension, like category&product etc.

Curious_George
Contributor
Contributor
Author

hello again,

so I think I figured out how to manually get rid of the the summary stat in the X and Y expressions (in the advanced options tab on the right side of screen, if the expression reads sum(X), I remove the sum, leaving just X in the expression box) -- but then in the chart, I get a statement saying that no chart is presented because the variables are undefined