Hi @flamber the query looks like the figure in below (Field filter from nested query · Issue #6449 · metabase/metabase · GitHub) but it contains way more attributes, kind like a wide table. Instead of writing the select statement for the subquery every single time when I create a question, I would love to save them as a separate question and be able to create different field filter for the new question that generate from it, the problem is that filed filter doesn't work with alias
basically, that's what I want to achieve: Using Field Filter in a view - #12 by abed, should I create a view in the metabase or in my db so that the date column will be able to set as field filter?