Data Visualization Examples: How to Create Pie Charts in Grafana
There are numerous data visualization examples in the glorious world of the Internet, but today we’re focusing on a good old classic sitting quietly in almost every data visualization dashboard: the pie chart.
Pie charts are mostly used when dealing with group or categorized data. As the name suggests, the pie-shaped chart represents the whole data, divided into multiple parts or slices. Each piece of the pie represents a subcategory of the complete data.
Pie charts can answer several questions:
- Which was the least traded stock volume last month?
- Which stock has the highest traded stock today?
- Who had the highest percentage of accrued votes in the last election?
In this tutorial, you’ll learn what pie charts are and how to use them in the open-source analytics and interactive visualization web application Grafana—using PostgreSQL and TimescaleDB.
Using a real-world stocks dataset, you’ll find a handful of data visualization examples on how to create beautiful and insightful pie charts in Grafana (with just SQL!). We’ll cover creating pie and donut charts with pre-aggregated data using arbitrary time intervals (
time_bucket) and show the transaction volume—all in the same panel.
Join us along for the ride!
If you need a database to store your time-series data and power your dashboards, try Timescale Cloud, our fast, easy-to-use, and reliable cloud-native data platform for time-series built on PostgreSQL. (You can sign up for a 30-day free trial, no credit card required.)