Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I’m trying to create a running sum of issues created over time. As seen below, issues are split by Function (A or B) and Severity (High/Low). I need my running sum to be partitioned by Function and Severity, so at any point I have a count of the issues created in each Function/Severity combination. The table is color coded to show the rows that should be considered together.
Date | Function | Severity | Issues Created | Running Open Issues |
1-Jan | A | Low | 3 | 3 |
1-Jan | A | High | 2 | 2 |
1-Jan | B | Low | 4 | 4 |
1-Jan | B | High | 1 | 1 |
2-Jan | A | Low | 1 | 4 |
2-Jan | A | High | 0 | 2 |
2-Jan | B | Low | 1 | 5 |
2-Jan | B | High | 1 | 2 |
3-Jan | A | Low | 1 | 5 |
3-Jan | A | High | 3 | 5 |
3-Jan | B | Low | 0 | 5 |
3-Jan | B | High | 1 | 3 |
I have searched extensively and unfortunately have not been able to get it working.
Primarily, I have tried: Aggr(RangeSum(Above(Sum(Issues Created),0,RowNo())), Function, Severity) , which returns nulls, and
RangeSum(Above(Sum(Total <Function, Severity> Issues Created),0,RowNo(Total)))
Please let me know of any suggestions - thanks for your help!
Bryan
For 2-Jan Why Low as 5?
Hi Anil,
Function = B, Severity = Low had 4 issues on 1/1 and 1 additional on 1/2, so the running sum on 1/2 is 5.