Forum Discussion
Date on x-axis - scatter plot
Hi Anonymous ,
“So if they were distinct (i.e. if i changed the data format back to have the timestamp) then it wouldn't be an issue?”
No.
In scatter chart, when you add non-numerical columns to the X axis, the Y axis is required to be aggregated (This is true even if your data does not contain duplicate rows.).
If you add a numeric column to the X axis, you don't have to aggregate.( even if there are duplicate rows ).
It may be because the Y-axis can only be numeric data and represent the size of the value in the chart, it is meaningless if it is not aggregated.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
So if they were distinct (i.e. if i changed the data format back to have the timestamp) then it wouldn't be an issue?
Community SupportHi Anonymous ,
“So if they were distinct (i.e. if i changed the data format back to have the timestamp) then it wouldn't be an issue?”
No.
In scatter chart, when you add non-numerical columns to the X axis, the Y axis is required to be aggregated (This is true even if your data does not contain duplicate rows.).
If you add a numeric column to the X axis, you don't have to aggregate.( even if there are duplicate rows ).
It may be because the Y-axis can only be numeric data and represent the size of the value in the chart, it is meaningless if it is not aggregated.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.