Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Create Simple Line Charts

Highlighted
8 - Asteroid

New to Alteryx, I am trying to create simple line charts similar to the ones created in the excel file attached but I am having difficult developing the workflow to create such line charts.  I understand this is probably a very easy fix but I am struggling with the chart configuration.  

 

I got the output => select => configure (but then I run into trouble when trying to develop the multi line chart)

 

Thank you in advance for all the help, 

 

Nick 

Highlighted
Alteryx
Alteryx

The trick is to use a layer for each line, so having your data split into columns and the time field in your left most column will make this layer creation easy. 

Highlighted
8 - Asteroid

So I tried to do this with transform and then create an individual chart, but the chart seems broken with lines missing and not connected from preop to final postop.  Is that because the [null]?  usually on excel I have it connect data points with missing data - like the excel attached. is this possible or where am I messing up?  I attached my workflow.

 

Nick 

 

Highlighted
Alteryx
Alteryx

Correct, the null values will not show a data point. You can address these missing values in the workflow, but otherwise they will not show a point. 

Highlighted
8 - Asteroid

Is there a way to make the program skip these null values and connect the line? 

Labels