Forum Discussion
Scatter plot summarizing data
I think that did it!
Take your x axis field and also drag it to "details".
This still does the aggregate, but for every unique value in the "details" field. If "x axis" and "details" are the same column, you get a point for every unique value of the x axis.
Great, willsmithorg !
I managed to "solve" this same issue based on your answer. But I add that in order to make it work, you should change the aggregation function in "x axis" from count or sum to MAX or MIN.
If you keep the count, the x axis will show the number of records of each value in the field, and that's not what we want to see. If you use MIN or MAX, considering that all the records of each group are the same, you will get the values you want for X axis.
I put "solved", because I don't consider this a real solution, but a workoroud.
This is great as a workaoround, but I think the tool should provide a better and more intuitive way of doing this.
Thanks!!
I've tried your suggestions and I can't generate a scatter plot without aggregation. The dataset is comprised of a datetime field and a decimal field. I want the dates to show along the x axis and the decimal score data along the y axis. How do I simply use the two values as cartesian coordinates and plot them on the x and y axis?
Thanks,
CJI've tried your suggestions and I can't figure out how to generate a scatter plot without aggregation. The dataset is comprised of a datetime field and a decimal field. I want the dates to show along the x axis and the decimal score data along the y axis. How do I simply use the two values as cartesian coordinates and plot them on the x and y axis?
Thanks,
CJ
