3 Replies Latest reply: Nov 9, 2018 10:14 AM by Bryan Richman RSS

    Running sum on specific dimensions

    Bryan Richman

      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