Chartio provides easy-to-use cloud-based data visualization / exploration service. Chartio users can query directly against Treasure Data, to quickly create Chartio reports and dashboards.
This documentation describes how to connect to Treasure Data from Chartio.
- Chartio account
- Basic knowledge of Treasure Dataa and its account
Step 1: Set up your Data Source
Please access the URLs below. Please replace
ORGANIZATION_NAME with your organization name on Chartio.
After that, choose
Direct Connection tab. Then you’ll see a screen as below. Fill in the following information:
Connect button. This lets you create new data sources, and will take a minute or two. If you have any problems, please contact
Next, go to Schema tab and press
Refresh Schema. You’ll see your tables on the display, and press
Apply. Then you can access these tables from charts!
Step 2: Create your Chart
Select your dashboard (please create if necessary), and click the
Add Element button at the right top of the dashboard screen. Then, select the
Data Source created above. A list of tables and fields will be shown on the left column. In this case, we’re using sample dataset containing 5,000 Apache weblogs.
Let’s 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.
Then, please drag
Code field to
Dimensions. Next, please press
Run Query button to fetch the results.
Finally, when you choose the diagram type, you can see the result as a pie chart, for example. Press
Save to put this on the dashboard.
Step 3: Design your Dashboard
You can add as many charts you want on your dashboard, and arrange them via drag & drop. There are couple of advanced features like ‘scheduled dashboard delivery with email’ and ‘exporting with PDF’ among others.
Please refer the Chartio documentation for further information.