Generate multiple visualizations from different groups of one query

Grafana Dashboards
1

I’m using v10.2.3 via the cloud/web interface.

I’m looking at time series data on the performance of a large variety of different products (20+). The data and the kind of visualization I want is exactly the same for each product; so the query for each one will be identical except for the single line specifying the product. (The data is multiple columns per product, and even if it was just one column, putting 20+ lines on a single chart would be unreadable, so they do have to be separate panels.) Additionally, we will be adding/removing new products on a continuous basis.

This all means I would love to write just one query, pulling the data for all these different products and grouping the results by a new column, and have Grafana generate a large collection/matrix of visualizations, one for each product. It would be massively easier than making 20+ individual viz panels and then continuously keeping them up to date. Is this possible?

2

please provide sample data od the groups and then the group details you want to viz

sounds like you want the repeat feature

3

! aha, that is exactly the keyword i needed, now that i know the feature is called “repeated panels” i’ve found the docs page. that’s just what i was looking for, ty.

for reference or anyone else reading this, I’m talking about data like this:

Column 1 Column 2 Column 3 Column 4 E
product week data1 data2 data3
product_foo 1/1/2024 NN NNN XYZ
product_bar 1/1/2024 OO OOO ABC
product_foo 1/8/2024 PP PPP DEF
product_bar 1/8/2024 QQ QQQ GHI

…where I want to have one visualization showing all three time series of just product_foo, and then another viz showing all three time series of just product_bar. The repeated panels feature will get me just that. Thank you @yosiasz

1 Like
4

image
image930×757 30.6 KB