Use rows in x axis

user08111

I have a data set that I created through a very complicated ETL. Below is a snap shot of what it looks like.

 

Year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec End Of YearActive

2010 2    5      1      9     12    15   5    9      4   33  12    15          120

2011

2012

2013

2014 

 

I need to build a multi line chart where the x axis has the months, the y axis has active clients and the lines represent the years. I am trying to build a chart that shows where we stand this year vs last year. I don't want to alter the data set as I had to spend multiple hours in ETL to get it to come out like this.

 

Any thoughts?

 

Faisal Velani

rado98

HI 

 

The easiest way I can think of (and unfortunately ti requires a dataset mod, a 1 tile mod in Magic ETL) is to collapse the data set so that you get a table like the one below

2010	Jan	2
2010	Mar	3
2010	Jul	8
2010	Dec	2
2011	Jan	3
2011	Mar	8
2011	Jul	2
2011	Dec	3
2018	Jan	8
2018	Mar	2
2018	Jul	3
2018	Dec	8

 

After that use "Month" as x-axis, "active users" as Y-axis and "Year" as Series.  That should give exactly what I think you want.