1 Reply Latest reply on Oct 22, 2018 6:04 PM by Zhouyi Zhang

    Week ago/Prior Week Calc

    Cindy Easton

      I need a calculation for looking at actions that occurred a week ago from the time the dashboard was posted.  I refresh the dashboard every Monday and used Today()-7 but the numbers are going down each day after Monday and that's not what I want to happen.  I want it to stay the same until I update the report the next week.

       

       

      Calc - Weekago:  Today ()-7

       

      Calc - New Action Since Prior week:  if [new action] >= [weekago] then 1 else 0 end