Get answers in a few clicks with the query builder

1

At the top-right corner in your Metabase, click New > Question to open the query builder. You can also get to the query builder by clicking Filter and/or Summarize at the top of a table or model, or clicking column headings and individual cells.

2

Select a table or a model or table you want to query, e.g. the Orders table from the sample dataset that ships with Metabase.

3

Click into Filters and select Created at. Select Last 12 months.

4

Click + to add another filter. This time select # Total, then from the dropdown menu, select Greater than, and enter 20.00 in the text box.

5

Next, click into Summarize and select Sum of… and select Taxes from the menu.

6

The by box next to it is where you’re going to group your results. First select Product > Category.

7

To further group these results by month, click + and select Created by, and choose month from the menu.

8

Hit the Visualize button. You’ll see a chart that shows how taxes are split across product categories on orders month over month.