Use rows in x axis

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

Comments

  • rado98
    rado98 Contributor

    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

    2010Jan2
    2010Mar3
    2010Jul8
    2010Dec2
    2011Jan3
    2011Mar8
    2011Jul2
    2011Dec3
    2018Jan8
    2018Mar2
    2018Jul3
    2018Dec8

     

    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.

This discussion has been closed.