In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Line Chart

BRRLL99
11 - Bolide

Hi 

I have Following data

 

CostsYEAR_1YEAR_2YEAR_3YEAR_4YEAR_5
Total Costs90150250250250
Total Benefits90200350550700

 

Expected Out:

 

BRahuL99_0-1664528742271.png

 

Same Type Markers for both lines

2 REPLIES 2
DataNath
17 - Castor
17 - Castor

Hey @BRRLL99, there's a few steps needed here.

 

1) You'll need to transpose your data so you get running name/continuous value fields that you can use for the axis:

 

DataNath_0-1664529030233.png

 

2) In the Interactive Chart you'll need to create a new layer, make it a line chart and select your measure for X/value for Y:

 

DataNath_1-1664529079362.png

 

3) Now, to split the chart into the 2 cost types, you'll want to go to Transforms > Split > Enabled > By [Costs] like so:

 

DataNath_2-1664529111897.png

 

The end result will give you this:

 

DataNath_3-1664529150429.png

 

If you want the dots along the lines as shown in your example, just got to Layer > By Type > Show > Points:

 

DataNath_0-1664529305051.png

JamesCharnley
13 - Pulsar

To add to the above post, if you specifically wanted the marks on the line too, you'll need to add another layer with the same settings that's a scatter instead of a line on top.

 

Edit: Above post was edited to make this comment obsolete. I have just learned something new about the interactive chart tool!

Labels
Top Solution Authors