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 Dataa and its account
Step 1: Set up your Data Source
Access the following URLs. Replace
ORGANIZATION_NAME with your organization name on Chartio.
After that, choose
Direct Connection tab. Fill in 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 Schema tab and click
Refresh Schema. You’ll see your tables on the display. Click
Apply. Then you can access these tables from charts:
Step 2: Create your Chart
Select your dashboard (create, if necessary), and click
Add Element which is located at the right top of the dashboard screen. Then, 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. Next, 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. Click
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 using drag & drop. You have can use advanced features such as ‘scheduled dashboard delivery with email’ and ‘exporting with PDF.’
Refer the Chartio documentation for more information.