4 Replies Latest reply on Dec 29, 2016 5:41 AM by ammar.khwaira

    Running Sum with Attr function using If statment

    ammar.khwaira

      Hi

       

      I have a situation where i need to create a dual axis line chart.  One line represent the running sum across weeks, and the other line represents running sum across weeks for critical issues only.

       

      i have created a calculated field which checks for priority if it is = 'Critical' , then get the running sum ( i have put Attr function to remove the error of mixing aggregate and non aggregate functions). This calculated field is not working, it gives empty results for the running sum.

       

       

      Week 1 should show :    Line 1 =   3 issues,    Line 2 = 1 critical issue.

      Week 2 should show :    Line 1 =   8 issues,     Line 2 =  4 critical issues.

       

      how to make ATTR works with running sum in this case ?

       

       

      Thank you.