Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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