I am trying to create two parameters, one the selects the date granularity and then based off this, one that allows for a certain lookback period to restrict the date range.
For example, I have the following parameter:
parameter: p_date_sel {
hidden: no
type: string
label: "3_Chart Granularity Selection"
allowed_value: {label: "Daily" value: "date" }
allowed_value: {label: "Weekly" value: "week" }
allowed_value: {label: "Monthly" value: "month" }
allowed_value: {label: "Quarterly" value: "qtr" }
allowed_value: {label: "Yearly" value: "year" }
default_value: "Week"
}
I then would like to add another parameter, essentially if they select the daily option, you can look back “Past 7 days,” “Past 14 Days,” “Past 30 Days.” If they select the weekly option, they will be able to select “Past 2 weeks,” “Past 4 weeks”, “Past 8 weeks.” I will have several lookback options depending on the date grain.
Is this possible to do, creating a second parameter that is dynamic off of another parameter? Or is there a better way to achieve this result? Thanks!