Query builder
The query builder makes it easy for anyone - even your less data-savvy teammates - to put together questions with just clicks, prompts, and, menu choices. No data expertise or SQL needed.
Point-and-click tool to self-serve data for those who don’t know SQL (and a mental-shortcut for those who do).
Click and select custom parameters to narrow down and group data from a dropdown menu.
Use joins to ask questions about data split across multiple models or tables.
Go beyond basic questions with custom expressions (they’re like formulas in spreadsheets, e.g., a CountIf formula).
Get a bit fancier with multi-level aggregation to stack more filters and summarizations step-by-step.
Check your question as you’re adding filters and summarizations without running the whole query, and make adjustments as you go.
Let anyone edit questions while keeping track of the question’s history. Metabase keeps the fifteen most recent versions of each question.
