In the visual question editor, I have a bunch of joins set up, and I'd like to filter to only show rows that have zero related rows in one of the joined tables.
In SQL terms, I think this would be something like HAVING count(joined_table.id) = 0
HAVING count(joined_table.id) = 0
Is something like that possible?
Hi @tslocke That would require something like this first: https://github.com/metabase/metabase/issues/11558 - upvote by clicking on the first post
Thanks - I'll upvote that.
Is there any way to do it meanwhile? e.g. can I add an SQL WHERE?
All else fails I could create a view, but I'd rather avoid that.
@tslocke The GUI does not allow SQL directly, since then Metabase wouldn't be able to understand it. You could perhaps use Models: https://www.metabase.com/docs/latest/users-guide/models.html