Hi all, This is may first post, and I’m a newbie. But wow, what a nice software this is! Anyway, I have created a pie chart with about 40 query’s (electricity kWh) of the current hour. Now, I will create one for ‘today so far’, ‘this month so far’ etc etc. I know I can copy the first chart, and m…

Welcome to the forum. What you describe is indeed possible. What happens to your Pie chart when you select Current Hour vs Last 24 Hours? From your query, it appears you are referencing the time picker (WHERE $timeFilter), so your query should be using the dropdown choices in the time picker.

OK, so that probably just shows my newbieness :grinning: I guess I don’t need WHERE $timeFilter then, because I only see the last hour anyways. (Nothing happens when I change the time in the dropdown) - still get the last hour. In this view, I’m trying to create, I would prefer to have fixed views …

You stated “so I don’t have to change every query every time I want a new time span?” There are two approaches: spend time up front to create as many “fixed” pie charts as you want, or create one pie chart that is tied to the time picker. Make sense? I would try to fix your query so that it DOES…

Yes, so I meant that changing all 40 query’s is a rather big job if I want, say, 5-10 pies. But maybe I actually need to do it, I just thought I should check if there’s a smart way than to copy/paste/edit all 200+ rows… :slight_smile: This is in a kiosk set-up, so once deployed, it should give the …

:grinning_face_with_smiling_eyes: Thanks for taking your time anyways, now I’m off to select music…

Is it possible to reuse same piechart query, but with different time span?

Grafana Configuration

grant2 December 2, 2021, 3:41pm 6

OK, got it. I know of no quick way to write the queries for the different pie charts. Just put on some good music and go to work!

1 Like

Topic		Replies	Views
Pie chart which contains an amount of elements that depends on the value given to a variable Dashboards	5	1171	September 27, 2023
Pie Panel interval	0	260	May 22, 2019
Pie-chart showing count of times in a timeseries within ranges InfluxDB	0	822	July 3, 2019
Pie chart Influxdb and Grafana InfluxDB	0	603	October 26, 2021
Pie chart shows value in last snapshot instead of last day of date range Grafana pie-chart	1	89	September 1, 2024

Is it possible to reuse same piechart query, but with different time span?

Related topics