Hi, can we set default parameter (type datetime) using relative date like those in filters?
When a user opens a dashboard, I want the parameter to start 2 weeks from current date.
So far I only can select last week at most, not last N weeks.
As of now, these are the only options for date parameters.
If you want to customize the default outside of these standard conditions then you can use a dynamic default date.
Hi @Azwan, I am marking Max’s reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!
I was hoping that Amazon could add this feature, the objective is for us to filter specified last N weeks instead of only previous week as a default in the parameter.
Dynamic default does not resolve the issue.
Another alternative solution would be filter relative date and time from a parameter, but it doesn’t have “exclude last N day/week/month/year”
Only “set dates relative to current date time” have the “exclude last N day/week/month/year” feature.
In regards to excluding, you could create a second filter that filters out all dates after the parameter you have. You could even create a calculated field that checks for a certain number of weeks after your parameter by taking the date difference from your parameter to your field in question.