6 Replies Latest reply: Aug 17, 2016 7:39 AM by shamly pt RSS

    Rolling 3 months in a chart

    shamly pt

      I wanted to show rolling 3 months in a bar chart.

      Dimension should be Claim_Month

      Expression should be Sum(Claim_Amount) for rolling 3 months.

       

      If I select current month(Aug), then the chart should show Jun, Jul, Aug in the dimension and in the expression Sum(Claim_Amount) for these three months.

       

      I have a date field Claim_Date, Month Field Claim_Month with the below inputs

      25-06-2016                                                     Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep

      26-06-2016

      27-06-2016

      28-06-2016

      29-06-2016

      30-06-2016

      01-07-2016

      02-07-2016

      03-07-2016

      04-07-2016

      05-07-2016

      06-07-2016

       

      I tried using this expression but it is throwing error

      Sum({<Claim_Year=, Quarter=, Claim_Month={‘>=$(=MonthStart(Max(Claim_Date), -3))<=$(=Date(Max(Claim_Date)))’}>} ClaimAmount )

       

      Please help friends. This is urgent