> ## Documentation Index
> Fetch the complete documentation index at: https://lightdash-docs-many-to-many.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Querying tables

> Now that you've connected your dbt project to Lightdash, it's time to start exploring your data.

A **Table** is the main starting point for exploring data in Lightdash. It contains a group of related dbt models, dimensions, and metrics. You **explore Tables in the Explore view**.

## An intro to Tables and the Explore view

[![tutorial creating saved chart explore](https://mintlify.s3.us-west-1.amazonaws.com/lightdash-docs-many-to-many/images/get-started/setup-lightdash/tutorial_creating_saved_chart_explore-96d73afc2e7313ccd63aed5a81766556.png)](https://youtu.be/2pQYuIT0674)

### There are 5 areas to the Explore view

To access the Explore view, you just need to go to `Explore` --> `Tables` -> then select the Table you want to explore.

<Frame>
  <img src="https://mintlify.s3.us-west-1.amazonaws.com/lightdash-docs-many-to-many/images/get-started/setup-lightdash/select-table-6bba83c0e68d0f0c13b7704a6103fdcc.jpg" alt="" />
</Frame>

The Explore view is really made up of 5 areas:

1. The list of metrics and dimensions available on the Table
2. The filters panel, which lets you restrict the data pulled into Lightdash
3. The chart panel to visualise the results of queries
4. The results panel to explore the results of queries as a table
5. The SQL panel, which shows the raw SQL that produced the results

<Frame>
  <img src="https://mintlify.s3.us-west-1.amazonaws.com/lightdash-docs-many-to-many/images/get-started/setup-lightdash/explore-screenshot-9a7cf0038620357e6842cbfe4968ab89.jpg" alt="" />
</Frame>

## How to create a saved chart from the Explore view in 5 easy steps

[![tutorial creating saved chart explore](https://mintlify.s3.us-west-1.amazonaws.com/lightdash-docs-many-to-many/images/get-started/setup-lightdash/tutorial_creating_saved_chart_explore-96d73afc2e7313ccd63aed5a81766556.png)](https://youtu.be/1hqRFy-wk98)

### Step 1: Select the Table you want to explore

Go to `Explore` --> `Tables` --> then select the Table that you want to explore.

<Frame>
  <img src="https://mintlify.s3.us-west-1.amazonaws.com/lightdash-docs-many-to-many/images/get-started/setup-lightdash/select-table-6bba83c0e68d0f0c13b7704a6103fdcc.jpg" alt="" />
</Frame>

### Step 2: Run your query

To run a query:

1. Select a metric to calculate
2. Select one or more dimensions to split the metric into groups
3. Hit "Run Query" in the top right

For example, if I wanted to know the "total number of orders split by order status", I'd select the `Unique order count` metric to calculate the number of orders and the `Status` dimension to split that by status.

### Step 3: Order the results in your table

Click on the three-dot-menu by your column headers and select the sorting option that you want for a column.

<Frame>
  <img src="https://mintlify.s3.us-west-1.amazonaws.com/lightdash-docs-many-to-many/images/get-started/setup-lightdash/sort-one-field-a3ef44cec240f802bf47c025c1f188d3.jpg" alt="" />
</Frame>

You can have multiple sorts by adding more columns using their three-dot-menu. You can see the number of sorts applied just above your results table.

<Frame>
  <img src="https://mintlify.s3.us-west-1.amazonaws.com/lightdash-docs-many-to-many/images/get-started/setup-lightdash/sort-multiple-fields-ca93335cbd0e31c5865fd1627940733b.jpg" alt="" />
</Frame>

You can update and change the sorting using of your table by clicking on the `sort` menu. Here, you have the option to:

1. Drag-and-drop columns to rearrange the order of sorting multiple columns.
2. Remove a sort
3. Change the order of a column's sort

<Frame>
  <img src="https://mintlify.s3.us-west-1.amazonaws.com/lightdash-docs-many-to-many/images/get-started/setup-lightdash/sort-options-4035607d31123aac06de138d50606133.jpg" alt="" />
</Frame>

### Step 4: Visualize query results as a chart

Once the query executes, the results will show in the results table. You can then open the charts section and choose a chart type to visualise the metric.

You can read more about [configuring your charts here](/references/chart-types).

<Frame>
  <img src="https://mintlify.s3.us-west-1.amazonaws.com/lightdash-docs-many-to-many/images/get-started/setup-lightdash/results-table-57fd9ea8ffd475e93b8748d90c6e62b3.png" alt="" />
</Frame>

### Step 5: Save your chart

Saved Charts allow you to save a specific chart or visualisation so you can share it or revisit it again in future.

When you open a saved chart, it will always update to display the latest data in your database

<Frame>
  <img src="https://mintlify.s3.us-west-1.amazonaws.com/lightdash-docs-many-to-many/images/get-started/setup-lightdash/save-chart-a85926a5410733a205368bb863884248.jpg" alt="" />
</Frame>

To save a chart:

1. In chart panel of the Explore view you will find the button to save your chart.
2. Enter a memorable name for the chart, a good idea is to use a question as the name "How many orders are there at each stage?"
3. Click on `Saved charts` to see your finished work of art