'Is there a way to create dynamic parameter?
I have filter for my dataset:
Keep rows where date is on or after $filter_date
Can I set parameter $filter_date to be 60 days (or 8 weeks or 2 months) away from today?
Solution 1:[1]
Great question!
You can use an expression paired with a dynamic parameter as such:
date_diff(current_date(), date1) <= $number_of_days
You can read more on the date/time functions here: https://www.palantir.com/docs/foundry/contour/expressions-relative-dates/#deriving-relative-dates
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|---|
Solution 1 | fmsf |