Passing a value from one dropdown as variable to load another dropdown

1

Hi, I am using two filters in a dashboard
image
I was able to load years. but when i select year i was unable to send the selected year to the quarter dropdown. I am loading the quarter dropdown from a new question.
How can i pass the selected year value?

image

2

Hey there, is a strict requirement fetching the quarter field from another question?

Otherwise you could

  • add a column quarter to the underlying table, and simply use it as a filter, in the same way you do for year
  • create an intermediate Metabase model in which you combine all the column you need for filtering purposes

Hope this helps!

1 Like