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
Try below calculation for week ago