# Create your first canvas

On the projects page, you can find all canvases that your team has created and your private canvases.\
\
Select the **+** icon in the grid to create a new canvas from the projects page.

## Import data

To import data, select the + icon.

To understand more about the data before importing, click on any of table names. 

## Explore data

### Filter <a href="#h_1107cde5e3" id="h_1107cde5e3"></a>

You can temporarily filter a column by any value or condition by right-clicking a column header.

If saved, filters will apply for others viewing the table simultaneously.

### Formulas

Click on the table header and select `Add Formula Column`.\
\
Enter a formula in the formula bar.

### SQL

Every table action is generated as SQL and vice-versa.

To inspect and edit a table via SQL, select the `sql` icon.

### Joins

Select the `join` icon to combine data from two or more tables without SQL.

Select which tables you would like to join.&#x20;

Preview different join types and save your desired join type.

### Hiding columns <a href="#h_6022a80396" id="h_6022a80396"></a>

Click the table header and select `Hide Column` to hide the column without removing it.

### Pivoting data

To summarize data as a pivot table, highlight the table by clicking the upper-left of the table. Then select the `pivot` icon in the navigation bar.

A blank pivot table will display on the canvas, while a menu will appear to configure the pivot table.

**Drag** a single source field or multiple source fields into a panel below to visualize data as a row, column, or value.

For **Rows or Columns**, select the **Details icon** and select the **sort orde**r to sort a row or column source field.

For **Values**, select the **Details icon** to summarize a value by any of the following:

* Count Unique
* Count
* Sum
* Average
* Minimum
* Maximum

### Visualizing data

You can visualize any data as a chart that will quickly show your team how your business is trending. 📊

Select the `chart` icon to visualize a selected table.

Select `chart type` to configure the chart as a:

* Bar
* Line
* Combo
* Pie
* Scatterplot

Configure how you want to display the chart:&#x20;

* Select Stacking to configure how the data should be plotted:
* `normal stacking` stacks the data series on top of each other in order
* `100%` fills the plot area and draws each point of data with a relative percentage to all the points in the same category
* Select x`-axis` to configure which source field appears horizontally in the chart.&#x20;
* Select `series` to configure which data series should display in the chart:
* If you are configuring a chart based on a pivot, toggle to the pivot menu to configure how you want to summarize a value.&#x20;
* `Select All` will display all data points in the table in the chart.&#x20;
* You can also customize the display name of each axis&#x20;