What is the correct way to setup a calculated field for a flag within 2 weeks of a date field?
Hello @jennifer.dankovic, just to clarify, do you want a calculated field to return all values from the selected date to 2 weeks after that date? I just want to make sure I am understanding your expectations here!
@jennifer.dankovic, my demo dataset is a little old and there are not any dates for 2026, but I built a calculated field in Arena to share with you: 2 Weeks from Date
If you view the analysis, and select the table visual, you can see the Date Filter calculated field and filter that I applied. It will use my calculation to determine the values to show, rather than filtering directly on the parameter value.
Let me know if this helps!