Filtering for NULL / empty in dashboard
**Is your feature request related to a problem? Please describe.** It seems I can't filter for NULL (or empty) values from a Dashboard Filter (or the inverse, IS NOT NULL). Within a question I can always filter a column with the "Is (not) empty". **Describe the solution you'd like** Add ability to all dashboard filters to filter for NULL and NOT NULL. **Describe alternatives you've considered** I suppose I can create a custom column to check for the NULL value. Or in the SQL coalesce it to NULL string (but how would it work then with integer columns... ) Anyhow both approaches feels hacky, is not intuitive and are not flexible. **How important is this feature to you?** High. Can be a deal breaker for choosing to continue with Metabase. **Additional context** For instance, if you have a Category column which can be optional. I would expect its possible to select records with a specific value, but also if they don't have a value. Below is an example how Datastudio shows it. <img width="334" alt="image" src="https://user-images.githubusercontent.com/4273556/177569584-9b67b0c9-bafa-482a-b49b-89d5625dc91d.png"> :arrow_down: Please click the :+1: reaction instead of leaving a `+1` or `update?` comment
Posted by joelluijmes on Jul 6, 2022, 2:08 PM
Tags
Related issues
- 2026 - Microsoft Office 365
- [Ubuntu] `ubuntu-latest` label will use Ubuntu 26.04 in November 2026
- Gamut mapping
- [Codex Desktop] Editing and resending a queued message triggers "App-server queued follow-up no longer exists"
- [Windows] ChatGPT 26.820.60940 fails with "invalid transport in mcp_servers.codex_app"; Beta 26.727.40816 works
- [BUG]: infinite loading of videos
Raise real-world problems, find people facing the same issue, and discuss solutions.2,500 issues0 comments
github (SaaS)
2026 - Microsoft Office 365
[Ubuntu] `ubuntu-latest` label will use Ubuntu 26.04 in November 2026
Gamut mapping
[Codex Desktop] Editing and resending a queued message triggers "App-server queued follow-up no longer exists"
[Windows] ChatGPT 26.820.60940 fails with "invalid transport in mcp_servers.codex_app"; Beta 26.727.40816 works
[BUG]: infinite loading of videos
Restore GPT-5.6 Sol’s 372k Codex context window, or provide an opt-in setting
Codex Desktop for macOS repeatedly triggers `syspolicyd` / `trustd` CPU and memory runaway
Filtering for NULL / empty in dashboard
**Is your feature request related to a problem? Please describe.** It seems I can't filter for NULL (or empty) values from a Dashboard Filter (or the inverse, IS NOT NULL). Within a question I can always filter a column with the "Is (not) empty". **Describe the solution you'd like** Add ability to all dashboard filters to filter for NULL and NOT NULL. **Describe alternatives you've considered** I suppose I can create a custom column to check for the NULL value. Or in the SQL coalesce it to NULL string (but how would it work then with integer columns... ) Anyhow both approaches feels hacky, is not intuitive and are not flexible. **How important is this feature to you?** High. Can be a deal breaker for choosing to continue with Metabase. **Additional context** For instance, if you have a Category column which can be optional. I would expect its possible to select records with a specific value, but also if they don't have a value. Below is an example how Datastudio shows it. <img width="334" alt="image" src="https://user-images.githubusercontent.com/4273556/177569584-9b67b0c9-bafa-482a-b49b-89d5625dc91d.png"> :arrow_down: Please click the :+1: reaction instead of leaving a `+1` or `update?` comment
Comments (0)
No comments yet. Start the discussion.