How To Create Pie Charts in Grafana With SQL

Опубликовано: 09 Сентябрь 2022
на канале: 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


Смотрите видео How To Create Pie Charts in Grafana With SQL онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Timescale 09 Сентябрь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 13,053 раз и оно понравилось 47 людям.