# 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;


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://canvasapp.gitbook.io/docs/getting-started/creating-your-first-canvas.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.