How To Create Pie Charts in Grafana With SQL

Published: 09 September 2022
on channel: Timescale
13,053
47

In this tutorial, you'll learn what pie charts are and how to use them in Grafana, using TimescaleDB and PostgreSQL. You'll find a handful of examples on how to create beautiful and insightful pie charts in Grafana with SQL using a real-world stock dataset. We'll cover creating a pie chart and donut chart, with aggregated data using arbitrary time intervals (using time_bucket), and show transaction volume in the same panel.

🛠 𝗥𝗲𝗹𝗲𝘃𝗮𝗻𝘁 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀
📌 Building a pie chart in Grafana (blog post) ⇒ https://tsdb.co/pie-chart-tutorial
📌 Getting started in TimescaleDB tutorial ⇒ https://tsdb.co/get-started-tutorial
📌 time_bucket() function ⇒ https://tsdb.co/time-buckets
📌 Building candlestick in Grafana ⇒    • Video  
📌 Grafana tutorial for beginners (setup TimescaleDB in Grafana) ⇒    • How To Set Up TimescaleDB and Grafana  

🐯 𝗔𝗯𝗼𝘂𝘁 𝗧𝗶𝗺𝗲𝘀𝗰𝗮𝗹𝗲
At Timescale, we see a world made better via innovative technologies, and we are dedicated to serving software developers and businesses worldwide, enabling them to build the next wave of computing. Timescale is a remote-first company with a global workforce backed by top-tier investors with a track record of success in the industry.

💻 𝗙𝗶𝗻𝗱 𝗨𝘀 𝗢𝗻𝗹𝗶𝗻𝗲!
🔍 Website ⇒ https://tsdb.co/homepage
🔍 Slack ⇒ https://slack.timescale.com
🔍 GitHub ⇒ https://github.com/timescale
🔍 Twitter ⇒   / timescaledb  
🔍 Twitch ⇒   / timescaledb  
🔍 LinkedIn ⇒   / timescaledb  
🔍 Timescale Blog ⇒ https://tsdb.co/blog
🔍 Timescale Documentation ⇒ https://tsdb.co/docs

📚 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀
⏱️ 0:00 ⇒ Introduction
⏱️ 1:52 ⇒ Creating a new panel
⏱️ 2:36 ⇒ Creating a pie chart
⏱️ 3:56 ⇒ Adding variables to grafana
⏱️ 5:00⇒ Using Grafana pie chart features
⏱️ 7:48 ⇒ Creating a stacked bar chart
⏱️ 10:53 ⇒ Outro


Watch video How To Create Pie Charts in Grafana With SQL online without registration, duration hours minute second in high quality. This video was added by user Timescale 09 September 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 13,053 once and liked it 47 people.