Chartio provides easy-to-use cloud-based data visualization and exploration service. Chartio users can query directly against Treasure Data, to quickly create Chartio reports and dashboards.
You can connect to Treasure Data from Chartio.
- Chartio account
- Basic knowledge of Treasure Data and its account
Set up your Data Source
Access the following URLs. Replace
ORGANIZATION_NAME with your organization name on Chartio.
Direct Connection tab. Edit the following information as shown:
Click connect to create new data sources. It will take a minute or two. If you have any problems, contact
Next, go to the Schema tab and click
Refresh Schema. Your tables are displayed. Click
Apply. Then you can access these tables from charts:
Create your Chart
Select your dashboard (create, if necessary), and click
Add Element which is located at the right top of the dashboard screen. Select the
Data Source created in the previous step. A list of tables and fields are shown on the left column. In this example, the sample dataset contains 5,000 Apache weblogs.
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.
Code field to
Dimensions. Click the
Run Query button to fetch the results.
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.
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.’
Refer the Chartio documentation for more information.