Issues in getting line chart in interactive chart tool

I am creating a dual axis chart using interactive chart tool. When I choose the chart type as "Scatter" the graph is displayed as below

But When I try to convert it into line chart, instead of getting a smooth line, I am getting the line chart as below

Am I missing any configuration here? Thanks in advance.

Help

Accepted answers

I'd work my way around this with a Top-Level category combining both, but I am not sure if this still matches the wanted output.

ToString([Cat 1]) + '_' + ToString([Cat 2])

The output gives me 14 individual graphs, that all have clean line graphs, but I can't tell if the output matches your expectations.

I'll attach the workflow and a PDF with all generated graphs. Let me know what you think.

Best

Alex

are the values on your x-axis strings or numbers? Are you able to provide sample data?

Best

Alex

X,Y1 and Y2 values are double. I am attaching the sample data. Thanks

I was able to get this:

While checking your data points, I noticed that you have multiple Y1 / Y2 for the same X.

I added a categorical variable to it using the Multi-Row-Formula:

I was then able to split the data using the Transform-Options for both Layers in the Interactive Chart:

Full workflow looks like this:

Workflow attached. Let me know what you think.

Best

Alex