# Chartio Export Integration

You can query directly against Treasure Data to quickly create Chartio reports and dashboards. [Chartio](http://chartio.com/) provides easy-to-use cloud-based data visualization and exploration service. See the [Chartio Documentation](https://chartio.com/docs/) for more information.

![](/assets/image-20191015-213503.e5c0384b3db73bde5644436b5b9cb7c98544388c4cb5a2b78bca3407478f55d5.a48cac9a.png)

# Prerequisites

- Chartio account
- Basic knowledge of Treasure Data and its account


# Set up Your Data Source

1. Access the following URLs. Replace ORGANIZATION_NAME with your organization name on Chartio.
https://chartio.com/ORGANIZATION_NAME/settings/datasources/new/presto/
2. Choose Direct Connection tab. Edit the following information as shown:


See the [API Doducmentation](https://api-docs.treasuredata.com/en/tools/presto/quickstart/#about-the-jdbc-driver-for-trinopresto) about JDBC settings.

[Trino Endpoints](https://api-docs.treasuredata.com/en/overview/aboutendpoints/)

![](/assets/image-20191015-213522.c0ec433a691c81ddc5e64003d1bf3378c36bec4037a85b0f0b9639a4d17a9902.a48cac9a.png)

1. Click **Connect** to create new data sources. It will take a minute or two.
2. Go to the Schema tab and click Refresh Schema. Your tables are displayed.
3. Click **Apply**.
4. Access these tables from charts:


![](/assets/image-20191015-213533.a6bb823dff705f5a40b9e67ac5aa17163a0e86515f5291c417ad6d77726b3e01.a48cac9a.png)

# Create Your Chart

1. Select your dashboard create, if necessary.
2. Click **Add Element** which is located at the right top of the dashboard screen.
3. Select the Data Source created in the previous step.
4. A list of tables and fields are shown on the left column. In this example, the sample dataset contains 5,000 Apache weblogs.


![](/assets/image-20191015-213601.6c40b121ac89bb5fb0a71a754753138b08139d3d348177d57fd8bd9dd5c0ea6d.a48cac9a.png)

Create the report of distribution of HTTP response code to ensure the website doesn’t return any errors. First, drag Code field to Measures. Then, select aggregation as Count of all Www Access.Code, and choose descending as sort order.

![](/assets/image-20191015-213620.58147319e8e2be462be921c34a1e54cd2f0b9dd7b10a3247ad880f8893a570a0.a48cac9a.png)

Then, drag Code field to Dimensions. Click **Run Query** to fetch the results.

![](/assets/image-20191015-213650.af2123d1a0b183bcc0dfd96394ce3171508617648422f516055d7cd334453e8e.a48cac9a.png)

When you choose the diagram type, you can see the result as a pie chart, for example. Click **Save** to put this on the dashboard.

![](/assets/image-20191015-213708.c284248f1e8eb71eb1b7a23ef2579bddcabb42211f7b58da186f0276bd739c0f.a48cac9a.png)

# Design Your Dashboard

You can add as many charts you want on your dashboard, and arrange them using drag & drop. You can use advanced features such as ‘scheduled dashboard delivery with email’ and ‘exporting with PDF.’

![](/assets/image-20191015-213720.e367307279ae58e640bbcef7acaad5c2a69d07d409afe5835c59567723b54cfe.a48cac9a.png)