Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi -
I've been working for hours to create a cumulative bar chart that has 2 dimensions and coming up flat.
Dimensions:
Month
Root Cause
Measure:
Case Number
I've read and read and read on this and can't get it to work. I'd like to see the culmination of the case number of each root cause category by month.
My Root Cause are the carious lines (i have about 4) and i'd like them to be culminated by month (if that helps).
here's my current equation
Aggr(RangeSum(Above(Count([Case Number]),0,RowNo())),[Root Cause], [Action Closure Date.autoCalendar.Month])
please help!
Lauren
Hi Lauren,
Try this:
RangeSum(Above(Count([Case Number]),0,RowNo()))
You don't need the aggr for this.
If you want more lines, use set analysis in the Count([Case Number]) to get multiple lines.
Jordy
Climber
Thank you! That's much closer than where I was. It looks like it's culminating up til May ... then it drops off. Any ideas?
Good, but this looks a bit strange indeed. Do you have some sample data to test with?
Jordy
Climber