Relative Date Filter for Agent

Summary

How do you put a relative date filter on an agent for an analysis?

Content

When creating agents for analyses, we would like to have agents that run with prompted filters on relative dates. I know that you can add a relative date filter in the analysis as a SQL filter. For example, for a report that runs weekly and pulls data from the previous seven days, "date variable" > TIMESTAMPADD(SQL_TSI_DAY, -7, CURRENT_DATE). However, we are looking to have more advanced capabilities in terms of the reports that we are able to run, i.e. a filter for the CURRENT week (a report that runs every day in a week, but pulls data from the same