I've got a large dataset of fisheries data going back to the 1980s for the entire state of Alaska. The dashboard I set up for it uses a selector to select the data by district, or I can further filter the district data by fishery year. So I'm using a district selector to filter a district list, and then the district list to filter a list of fishery district ID's and available years (District Year List). The user can view and download the entire district dataset or a specified year in the district dataset. There are three different data tables being used, all of which come from our SQL Server database.
Unfortunately in the mobile view, there aren't any actions for lists, which in this case defeats the purpose of the dashboard. Has anybody found a work around to use a list to filter another list? I really don't want to redesign our database to make this work.