I think I'm off the mark here ... but can you not use
[Date]>=today()-7 and [Date]<=today()-1 within the calculated field?
This will keep it rolling.
We've also used a "Show/Hide" in the past for some sheets that works well.
Sample book attached, but if you're able to attach a sample similar to what you are looking for that would be good too.
235483.twbx 75.7 KB
Thanks for the response. I'm not sure your solution will work for my case. I don't think I was clear about the fact that I'm trying to make this work specifically in a line chart showing weekly values for a calculated ratio. I can't really share the workbook I'm working on due to sensitive business data but here's a screenshot.
The left viz is just the WEEK(Created Date). The right viz is Day(Created Calc) where the calc is: Datetrunc('week', [Created Date], 'tuesday')
Since today is Tuesday and I want the last datapoint to always be a full week ending yesterday, anyway to get 'tuesday' to be dynamically set to today's day of week is what I'm looking for.
Hopefully that clarification makes sense, but let me know if not.