Dashboard Filtering with 2 query tables using one filter field

Dashboard Filtering with 2 query tables using one filter field

Hi There,


I have been using user filters on the dashboard and for the most part they are fine. However I have one issue I would like to see if there is a fix for it.


I have a main query that most of my widgets use. Then I have a second query for another widget. The dashboard uses the field "brand" in the main query for the filter. 


The second query uses the main_query.brand field alongside fields from a second table. I have set the widget to use main_query.brand as a filter, but when the dashboard fitlers on "brand" only the widgets directly using this query table work. The level 1 dependancy (second query) which also has this field (brand) does not work on filtering. Any ideas why the dependency level does not use it and can I fix that?


Thanks,

Leon