I have a date field “date” and I have created parameter, I want to create a dynamic calculation when user select the parameter last 90 days like that
Hello @Alam_Syed , welcome to the QuickSight community!
There are a few different ways to do this. Here is an example of something I made recently when I was in a pinch:
Date choice w/ parameter
One note on this, because I made it quickly it requires a filter on the visuals to remove NULL. I did this by setting a date filter with the condition as AFTER and choosing a date in the past that my users wouldn’t go farther back than.
1 Like
HI @duncan Thanks for the solution,
Awesome this is what I was looking for.
One think the the end of the calculation script you have given NULL, this NULL I am not able to give the condition in the filter card, I need to chose filter setting after.
It will good to have instead of NULL can we have 1,0 so that I can pass this condition into the filter.
1 Like