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.
Solved! Go to Solution.
Hi @MaliniLakshman,
are the values on your x-axis strings or numbers? Are you able to provide sample data?
Best
Alex
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
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.
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
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.