Linked Filters not working when passing questions to a dropdown list

[srikanthg]

First, We have created a SQL Question: CalYear, to get list of years from a table.
The query we've executed is: Select Year from common.calyear;
After executing the query, we ‘re getting the following result:

Secondly, We’ve created an another question: Quarters for year
The query we’ve executed is:
SELECT
oq.name as Quarter, year as Year
FROM
worktracker.orgquarter oq
JOIN common.calyear ON calyear.id = oq.calyear
WHERE year= {{selected_Year}}::integer

For Selected_Year variable, we are using dropdownlist filters from the above question: CalYear
After executing the query with a value set as 2024, we’ve got the following result:

Now, I have created a new dashboard : Sprints Data Dashboard
For this dashboard, we’ve added two filters: Year and Quarter
For populating the year dropdown, we’re using the question: CalYear.
For populating the quarter dropdown, we’re using the question: Quarters for year.
We’ve the following problems here:

1. When we select year from the year dropdown and click on update, the quarters dropdown is not showing up any data.

2. When I try to link the year filter to quarter filter in the ‘Linked filters’ section, It is not showing up any toggle for year., but when we choose to select the filter as input, the toogle for year is not showing up, until I remove the question from the dropdown list filter.

How can we solve these two scenarios here.
Any help would be appreciated.
Thanks

[leeloo]

So - you can't link filters that also use another card/question as the source list for the filter. You can read a little more here about the limitations of field filters and how they can be used.

How did your "Year" and "Quarter" columns because a part of the "OrgSprint" question? Are they strings? Is the full date also available?

[srikanthg]

There is no Full date available.
We're using a table called Calyear, where year is stored as int.
And in orgquarter table, quarter name is stored as string.