2 Replies Latest reply on Nov 2, 2017 3:22 PM by Oury Diallo

    Display last week  (From saturday to Sunday)

    Oury Diallo

      Hello Team ,

      I am trying to display   Last Week  total cnt    (10/21/17 to    10/29/17)  I want to refresh this dynamically without hard coding the dates.
      like I did for the calculation below.

       

      YTD: Year to date

      if(YEAR([Metric
      date])=YEAR(TODAY()) )

      then

      [Total Cnt]

      end

      MTD:   Month to date

       

      if (MONTH([Metric
      date])=MONTH(today()))

      then

      [Total Cnt]

      end

      Yes: Yesterday

      if([Metric date]=(TODAY())-1
      and   NOT ISNULL([Total Cnt]))

      then

      [Total Cnt]

      End

      Last Week   ??????  
      See the sample output of my data.

      Metric_Rate.PNG