The simplest way to query your data using Count is using drag-and-drop. This method allows you to analyze data from any:
- tables in your project
- cells in your notebook
without having to know SQL, or even if you do know SQL, it's a much quicker way to build your queries.
The video shows you how to:
- create a cell
- select columns to query
- add a filter
- visualize your results
1. Create a Cell
You can create a cell by typing
// or clicking the Add cell button at the bottom of the notebook.
2. Drag the columns and/or tables that you want to query
Use the left-hand data bar to see the data you have available to query. This will include:
- data from your project
- cells from your notebook
Simply drag in the column names you want to see, or drag in the entire table.
Note: the drag-and-drop aggregation options are a subset of what's available in code mode. If you need to do something that's not available in drag-and-drop, check out our Querying Data - SQL or Querying Data - Notebook SQL guides.
3. Customize Query
Once you've selected each column or table, you can click each pill and change the aggregation, or function applied to that column.
4. Add Filters
Use the + Add a filter button to filter on any column from any table that's been used in your select options.
You can add as many filters as you need.
Multiple filters will be either all "and"-ed, or "or"-ed. If you need some ands, and some ors, you can switch into Code mode to edit the query.
Note: this means you can't filter from a table that doesn't have a column in your query.
5. Visualize your Results
By selecting Visual as your output type you can see a chart of your data instantly.
Check out the Visualization section to learn more about how to customize your visualizations.