user08111

Discussions

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…
Adding Two Rows
I have a dataset listed below: Year Gain Loss Net 1999 10 5 5 2000 15 20 -5 2001 12 9 3 2002 19 8 11 2003 17 21 -4 2004 18 3 15 I need to create a new column that has a sum of all active clients for that year: Year Gain Loss Net Active 1999 10 5 5 5 2000 15 20 -5 0 2001 12 9 3 3 2002 19 8 11 14 2003 17 21 -4 10 2004 18 3…