I have a dataset like:
quarter,faculty, people
2016-Q1,LAW,2
2016-Q1,BUSINESS,11
2016-Q1,EDUCATION,2
2016-Q2,BUSINESS,11
2016-Q2,BUSINESS,7
2017-Q1,LAW,5
2017-Q1,LAW,1
2017-Q1,EDUCATION,3
2017-Q1,EDUCATION,4
2017-Q1,EDUCATION,2
I'm trying to get the cumulative total by quarter of people per faculty
And display this in a chart so that the people count is on the y axis, the quarter is on the x-axis and the graph is stacked by faculty.
e.g.
I can get the (summed) people count as a chart, by doing this:
search | chart sum(people) over quarter by faculty
So the data would look like:
2016-Q1
LAW = 2
BUSINESS = 11
EDUCATION = 2
2016-Q2
LAW = 0
BUSINESS = 18
EDUCATION = 0
2017-Q1
LAW=6
BUSINESS = 0
EDUCATION = 9
But I want to get the cumulative people count, so that the counts end up more like
2016-Q1
LAW = 2
BUSINESS = 11
EDUCATION = 2
2016-Q2
LAW = 2
BUSINESS = 29
EDUCATION = 2
LAW = 8
BUSINESS = 29
EDUCATION = 11
I know there is an accum function but I can't get this to play with chart.
Any ideas how to do this?
... View more