Creating two parameters, one dependent on the other

[jonathan_laks-1]

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!

[IanT]

It’s only possible to do in a dashboard, I tried a fair few things but no way to run the 2nd filter population on action of 1st - apart from on a dash.

https://community.looker.com/lookml-5/cascading-filters-using-lookml-8894

[sraghuvaran_cna]

Hi @IanT , I have similar use case and I would like to do it at dashboard level. The link you have provided  is not working now. Is there any other documentation that you can provide?