Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Create Simple Line Charts

Faronnj
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 

4 REPLIES 4
BrandonB
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. 

Faronnj
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 

 

BrandonB
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. 

Faronnj
8 - Asteroid

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

Labels