Using dashboard filters to filter the query without including column in the result

Get Help
4

@ramiouanes Then you'll need to create a lookup table with all dates available - something like

with mycte as (
    select min(date_col) as start, max(date_col) as end
    from lookup_date_table
    where {{field_filter_range}}
)
select employees.*
from employees, mycte
left join another_employees on aeid=eid
where
  employees.date between mycte.start and mycte.end
  or another_employees.date between mycte.start and mycte.end

When this issue is fixed, then you might be able to use a Custom Column via a GUI question, but I'm not completely sure yet:
https://github.com/metabase/metabase/issues/17775 - upvote by clicking :+1: on the first post