Apply dashboard filter before question aggregation

Hi,

I would like to add the dashboards filters to a question but before aggregation happens. The only option I see is that Metabase automatically add the fitler to the last stage of the question.
Example:
Metabase add the filters atuomatically here:

but I want it to happen here (in this picture I have added the filters by hand in the qeustion, and therefore they are static and not affected by the dashboard question which goes to end again):

Any ideas?
Thanks in advance

Hi @eclar
You would have avoid the Custom Column, otherwise you would have to use SQL.
Latest release is 0.44.4: https://github.com/metabase/metabase/releases/latest

1 Like