3 Replies Latest reply on Sep 11, 2017 11:49 AM by Vinh Ton

    LOD calculation for aggregating over a date range?

    Vinh Ton

      Suppose there is a daysRange parameter that is set to 2.

       

      Is there a LOD expression approach to

      sums the value 2 days back including current day.

       

      I do need LOD specific solution as the example below is for simple demonstration only.

      My actual implementation will not be using tables.

       

      Thanks ahead

       

      DateValueSumOverRange
      1-Jan11
      2-Jan22+1=3
      3-Jan33+2=5
      4-Jan47
      5-Jan59
      6-Jan611
      7-Jan715