Forum Discussion
Duplicated values added together in scatterplot
I realise that this is an uncommon problem, but in the event that anybody else experiences this problem, I figured out the solution, which is below:
First, every single row of data needs to have a unique ID. You can do this by creating an index column in the query editor by doing the following:
This Index column then needs to be entered into the 'Unique ID' field in the Craydec Regression Chart visual:
That then means that every single row of data you have is plotted as an individual data point -- no funny behaviour with duplicate values.
I realise that this is an uncommon problem, but in the event that anybody else experiences this problem, I figured out the solution, which is below:
First, every single row of data needs to have a unique ID. You can do this by creating an index column in the query editor by doing the following:
This Index column then needs to be entered into the 'Unique ID' field in the Craydec Regression Chart visual:
That then means that every single row of data you have is plotted as an individual data point -- no funny behaviour with duplicate values.