X-axis values get repeated in Line Chart and not in ascending order

[vjeeshc]

We have a requirement to display a line chart wherein duplicate values might be there for Argument Data Column. The expected behavior is to display only unique values along the X-axis. But what happens now is that all duplicate values get displayed in the X-axis (only numeric values are provided for X-axis). Also, the values along the X-axis are not in ascending order. How can we fix this issue? Please advise

[HighAley]

Hello.

Our charts can't process data this way.
You should prepare data for the chart.
You could use the Data Source from Other Data Source or Data Transformation for this.

Thank you.

[vjeeshc]

My bad, i picked up the wrong chart type. Using Scatter Line chart instead of Line chart would fix this issue

Thank you.

[Andrew]

Okay, thank you for sharing your solution