Forum Discussion
Help with scatter chart
Hi everyone,
I have a problem with a visual.
I have a table with 600k+ rows.
I need to create a visual that allows me to see how many observations are made in a day and report the individual values (no sums and so on).
I cannot share files or data due to the company's privacy restriction.
I tried to create a scatter chart by inserting the dates on the X-axis and thinking of inserting the column containing the observation values on the Y-axis, instead it returns the values.
I tried to create another scatter chart also inserting the IDs as a legend, but they are colored in many different ways and I need a single color.
What do you recommend?
2 Replies
Hi Anonymous -If you prefer to use the scatter chart, avoid the issue with multiple colors add X-Axis>> Date column and Y-Axis: observation values.Legend: ID column as a legend but set all the points to the same color.Go to the "Data colors" >> Choose a single color that will apply to all points regardless of the ID.To make sure no unintended aggregation happens, ensure that the summarization is set to "Don't summarize" for the Y-axis.
you can also try to use charts like Line charts with non-summarized data on the Y-axis can offer a clear view of individual observations over time and Scatter charts with a single color and no legend can give you a clean visual representation.
Hope the above information helps.
