This tutorial will walk you through creating your first chart in Chartio. In just a few minutes, you'll be visualizing the top 5 delinquent customers by plan amount based on Stripe invoice data stored in dashDB! Before starting this tutorial, make sure you have completed the Getting Connected tutorial. Don't hesitate to contact support if you run into any issues!
- Create a new dashboard, name it, categorize it and click "Create Dashboard"
- Navigate to the Chart Creator by adding a Chart element
- Search for the
St Customer
table - Drag
Email
into Diemnsions andDelinquent
into Filters, filter on "equals 1" - Drag
Plan Amount
fromSt Customer Subscriptions
into Measures, sort descending - Limit the result set to 5 and click "Refresh Chart"
- Use the Data Pipeline to divide the
Plan Amount
in cents by 100 to get dollars - Change the visualization from table to bar chart
- Navigate to the Chart Settings, title the chart and y-axis and click "Done"
- Save the chart to the dashboard