Forum Discussion

Regular Visitor

4 years ago

Scatter Plot missing duplicate rows

Hi all, I'm using a measure to create a percentile chart that's dynamic based on filters. It works fine when displayed as a table, but the scatter plot visualization is removing any point with dupli...

Anonymous

Not applicable

4 years ago

I'm afraid it is by design.

If you remove the index from table visual, it will also remove duplicate rows.

Best Regards,

Jay

gsmayes
Regular Visitor
4 years ago
It's strange because I have a column in my data table which calculates percentile by station that was brought in from the excel data source. When I plot this the duplicate rows are shown (but doesn't dynamically recalc based on filters). So it appears this problem is only present when plotting a measure?

Also, if there was a batch way to change point color that could be a solution, but it appears I have to manually change color using the dropdown for 300+ points. FYI, I changed legend to time stamp because it's also unique and actually useful information that displays in the tooltip.
- lbendlin
  Super User
  4 years ago
  One other way to prevent involuntary grouping is to add small, inconsequential random amounts to each data point.