Forum Discussion
Scatterplot - I don't want the Y-axis measure aggregating
I was able to work out the solution. It came down to understanding the visual a bit better. Also, if the answer lie in the several post I looked at, I completely missed it. Basically, I was able to make measures for BOTH the x-axis and the y-axis. Then, I added a column value (i.e., the primary key) in the "Values" box. This plotted a dot for each row, at the coordinates of the two measures. This addition allowed the aggregation to work for EACH ROW rather than each unique result (which could involve more than one row--e.g., all rows where the measured equalled zero) in the x-axis measure. In previous attempts to use that Values box, with only one axis defined or only one measure in play, it would not work, and I had ignored it until this last attempt. The legend was used to separate the different values which were independent raw values in a narrow table.
I was able to work out the solution. It came down to understanding the visual a bit better. Also, if the answer lie in the several post I looked at, I completely missed it. Basically, I was able to make measures for BOTH the x-axis and the y-axis. Then, I added a column value (i.e., the primary key) in the "Values" box. This plotted a dot for each row, at the coordinates of the two measures. This addition allowed the aggregation to work for EACH ROW rather than each unique result (which could involve more than one row--e.g., all rows where the measured equalled zero) in the x-axis measure. In previous attempts to use that Values box, with only one axis defined or only one measure in play, it would not work, and I had ignored it until this last attempt. The legend was used to separate the different values which were independent raw values in a narrow table.