Issues in getting line chart in interactive chart tool

[MaliniLakshman]

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.

[grossal]

Hi @MaliniLakshman,

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

Best

Alex

[MaliniLakshman]

Hi @grossal 

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

[grossal]

Hi @MaliniLakshman,

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

[MaliniLakshman]

Hi @grossal 

Thanks for your quick response. I do have 2 categorical values in my data. I am using that variables as 'group by' variables  in 'batch' and create separate graphs for those. 

I downloaded your workflow and checked it. I did exactly the same except the batch. Still I am not getting the graphs correctly.

I couldn't use split as I have to use 2 categorical variables to split my data. I will upload my workflow soon for your reference.

[MaliniLakshman]

Hi @grossal 

I am attaching the packaged workflow for your reference. Thanks

[grossal · Accepted solution]

Hi @MaliniLakshman,

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

[MaliniLakshman]

Hi @grossal 

It worked. Thank you so much.

I didn't combine the categorical variable but I sort X in ascending order. That did the trick and I am getting the graphs perfectly now.