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!
Hope everything is well with you! Just checking back in since this thread hasn’t received a response in a while. Was the reply above helpful to you or were you able to find a solution yourself in the meantime? Please help the community by marking this answer as “Solution” or following up in general within the next 3 business days!
Since I haven’t received any further updates from you, I’ll treat this inquiry as complete for now. If you have any additional questions, feel free to create a new post in the community and link this discussion for context.
Thank you.