# \#influxql **URL:** https://community.grafana.com/tag/influxql/279.md [Latest](https://community.grafana.com/latest.md) · [Categories](https://community.grafana.com/categories.md) · [Tags](https://community.grafana.com/tags.md) --- ## [Graphing rate per second from randomly timed deltas](https://community.grafana.com/t/graphing-rate-per-second-from-randomly-timed-deltas/161526)
**Author:** [@mnewton3](https://community.grafana.com/u/mnewton3)\ **Replies:** 5\ **Last updated:** [February 6, 2026, 4:37pm UTC](https://community.grafana.com/t/graphing-rate-per-second-from-randomly-timed-deltas/161526 "2026-02-06T16:37:53Z")
Hey all, I’m having some trouble charting some data, and it looks like InfluxQL may not be able to do what I need. That is, do some math using the time difference between two rows. So I’m hoping that Grafana can do the w… --- ## [Grafana Influxdb Flux Query](https://community.grafana.com/t/grafana-influxdb-flux-query/160071)
**Author:** [@uniquewaheed](https://community.grafana.com/u/uniquewaheed)\ **Replies:** 3\ **Last updated:** [December 10, 2025, 10:43am UTC](https://community.grafana.com/t/grafana-influxdb-flux-query/160071 "2025-12-10T10:43:59Z")
Hello All , am using influxdb query for displaying on grafana dashboard for cisco IOS XE devices. As variable am able to create list of Source devices and their interfaces , but not able to show respecitive MAC address … --- ## [Create InfluxQL query with optional filter variables on Library Panel](https://community.grafana.com/t/create-influxql-query-with-optional-filter-variables-on-library-panel/144677)
**Author:** [@albertoglezc](https://community.grafana.com/u/albertoglezc)\ **Replies:** 3\ **Last updated:** [August 8, 2025, 12:03pm UTC](https://community.grafana.com/t/create-influxql-query-with-optional-filter-variables-on-library-panel/144677 "2025-08-08T12:03:29Z")
After much research I have managed to develop this trick to be able to invoke a library panel (for example, table type), where the query uses one or more variables as filters in an optional way. In this way I can use th… --- ## [Make query B,C and D dependend to the results of query A](https://community.grafana.com/t/make-query-b-c-and-d-dependend-to-the-results-of-query-a/154146)
**Author:** [@YM92](https://community.grafana.com/u/YM92)\ **Replies:** 4\ **Last updated:** [July 14, 2025, 7:02am UTC](https://community.grafana.com/t/make-query-b-c-and-d-dependend-to-the-results-of-query-a/154146 "2025-07-14T07:02:31Z")
Hi guys, i am trying to build a dashboard where i have multiple queries. Query A returns the initial data i need to work with and i want query B, C and D to only rely on the data that comes from query A. Better said, … --- ## [Creating a Bar Chart for Non Time Series Data](https://community.grafana.com/t/creating-a-bar-chart-for-non-time-series-data/152523)
**Author:** [@izw](https://community.grafana.com/u/izw)\ **Replies:** 6\ **Last updated:** [June 17, 2025, 3:45pm UTC](https://community.grafana.com/t/creating-a-bar-chart-for-non-time-series-data/152523 "2025-06-17T15:45:46Z")
What Grafana version and what operating system are you using? → Grafana Cloud with InfluxDB\_SODA What are you trying to achieve? → a bar chart that counts how many times individual values appear. How are you trying… --- ## [Variable evaluation fails when expression added](https://community.grafana.com/t/variable-evaluation-fails-when-expression-added/136157)
**Author:** [@ushi](https://community.grafana.com/u/ushi)\ **Replies:** 5\ **Last updated:** [June 11, 2025, 10:17am UTC](https://community.grafana.com/t/variable-evaluation-fails-when-expression-added/136157 "2025-06-11T10:17:20Z")
What Grafana version and what operating system are you using? \[v10.1.9\] What are you trying to achieve? An InfluxDB query with a math operation that involves a variable with a decimal point What happened? the … --- ## [Add Treshold below some min value](https://community.grafana.com/t/add-treshold-below-some-min-value/147265)
**Author:** [@askic](https://community.grafana.com/u/askic)\ **Replies:** 2\ **Last updated:** [March 27, 2025, 10:00am UTC](https://community.grafana.com/t/add-treshold-below-some-min-value/147265 "2025-03-27T10:00:54Z")
Hello, I’m very new to Grafana and I have watched some basic YT videos for beginners. They were quite helpful to get started. However I have come across to a problem that was already discussed before, but was not able … --- ## [How to threshold a time-series with InfluxDB 1.8?](https://community.grafana.com/t/how-to-threshold-a-time-series-with-influxdb-1-8/146179)
**Author:** [@packoman](https://community.grafana.com/u/packoman)\ **Replies:** 1\ **Last updated:** [March 12, 2025, 3:59pm UTC](https://community.grafana.com/t/how-to-threshold-a-time-series-with-influxdb-1-8/146179 "2025-03-12T15:59:00Z")
What Grafana version and what operating system are you using? Grafana 9.2 Ubuntu 20.04 InfluxDB 1.8 What are you trying to achieve? I have the following InfluxDB query (using InfluxDB 1.8): SELECT "apower" AS power\_s… --- ## [Group data and set tag name as value name](https://community.grafana.com/t/group-data-and-set-tag-name-as-value-name/145502)
**Author:** [@moselwiese](https://community.grafana.com/u/moselwiese)\ **Replies:** 6\ **Last updated:** [March 7, 2025, 8:03am UTC](https://community.grafana.com/t/group-data-and-set-tag-name-as-value-name/145502 "2025-03-07T08:03:42Z")
Hello, I’m using Grafana 11.5.2 and I am currently facing issues with plotting GPS data. I am using InfluxDB as datasource. My database provides grafana with values, which I want to have separated based on there freque… --- ## [Rolling Sum Visualization with InfluxDB3 and InfluxQL](https://community.grafana.com/t/rolling-sum-visualization-with-influxdb3-and-influxql/144396)
**Author:** [@abalu](https://community.grafana.com/u/abalu)\ **Replies:** 0\ **Last updated:** [February 19, 2025, 4:24pm UTC](https://community.grafana.com/t/rolling-sum-visualization-with-influxdb3-and-influxql/144396 "2025-02-19T16:24:36Z")
I’ve looked everywhere but cannot find a good solution for this. Basically I have an influxdb3 time series with data points coming in randomly around every 1 ms. Each data point contains x and y. I want to visualize th… --- ## [How to Set Different Timeframes for Multiple Time Series Panels in Grafana?](https://community.grafana.com/t/how-to-set-different-timeframes-for-multiple-time-series-panels-in-grafana/143212)
**Author:** [@bertschelstraete](https://community.grafana.com/u/bertschelstraete)\ **Replies:** 4\ **Last updated:** [February 12, 2025, 4:30pm UTC](https://community.grafana.com/t/how-to-set-different-timeframes-for-multiple-time-series-panels-in-grafana/143212 "2025-02-12T16:30:56Z")
Hi everyone, I’m working on a dashboard with multiple time series panels in Grafana, but I need each panel to display a different timeframe in order to showcase some pressure tests we ran with our pneumatic conveyors. H… --- ## [How do I properly display this value from Nagios in Grafana?](https://community.grafana.com/t/how-do-i-properly-display-this-value-from-nagios-in-grafana/140812)
**Author:** [@riahc3](https://community.grafana.com/u/riahc3)\ **Replies:** 16\ **Last updated:** [January 21, 2025, 5:49pm UTC](https://community.grafana.com/t/how-do-i-properly-display-this-value-from-nagios-in-grafana/140812 "2025-01-21T17:49:37Z")
Hello Im not sure how to explain this so Ill just post some screenshots I have the following in Nagios: As we can see, that is the only performance data being returned In Grafana, Im getting that performance data … --- ## [Identifying identical queries from different influxdb datasources](https://community.grafana.com/t/identifying-identical-queries-from-different-influxdb-datasources/137186)
**Author:** [@RocketSurgeon](https://community.grafana.com/u/RocketSurgeon)\ **Replies:** 3\ **Last updated:** [November 28, 2024, 12:47pm UTC](https://community.grafana.com/t/identifying-identical-queries-from-different-influxdb-datasources/137186 "2024-11-28T12:47:43Z")
Howdy, I’ve two data sources, each running the exact same InfluxQL memory usage query, returning data in table mode. Both return a series called “mem”, the name of the measurement in question. I want to merge these two d… --- ## [How to create a histogram grouped by a tag](https://community.grafana.com/t/how-to-create-a-histogram-grouped-by-a-tag/136929)
**Author:** [@krzaq](https://community.grafana.com/u/krzaq)\ **Replies:** 0\ **Last updated:** [November 22, 2024, 10:35pm UTC](https://community.grafana.com/t/how-to-create-a-histogram-grouped-by-a-tag/136929 "2024-11-22T22:35:55Z")
What Grafana version and what operating system are you using? Arch, version: 11.2.2, commit: c47b921ef40 What are you trying to achieve? I have an InfluxDB table that stores stats about my web server, specifically… --- ## [How to get the start or stop of time window ($timeFilter work, $timeTo not)](https://community.grafana.com/t/how-to-get-the-start-or-stop-of-time-window-timefilter-work-timeto-not/136284)
**Author:** [@mazas](https://community.grafana.com/u/mazas)\ **Replies:** 6\ **Last updated:** [November 13, 2024, 5:14pm UTC](https://community.grafana.com/t/how-to-get-the-start-or-stop-of-time-window-timefilter-work-timeto-not/136284 "2024-11-13T17:14:36Z")
Using Grafana cloud with Influxdb3/InfluxQL. Trying to get specific time periods within a window. This works: SELECT time, extruder\_target FROM "gantry" WHERE $timeFilter However, this does not: SELECT time, extrude… --- ## [The request does not convert data from UTF-8 to FLOAT](https://community.grafana.com/t/the-request-does-not-convert-data-from-utf-8-to-float/135419)
**Author:** [@vab1](https://community.grafana.com/u/vab1)\ **Replies:** 1\ **Last updated:** [October 31, 2024, 1:33pm UTC](https://community.grafana.com/t/the-request-does-not-convert-data-from-utf-8-to-float/135419 "2024-10-31T13:33:10Z")
Hello everyone. Here is the following request: SELECT SUM("slotRenderEnded"::float) slot\_Render\_Ended, date\_bin(INTERVAL '$GROUP\_BY\_TIME\_SQL', time) as time, extension FROM "productionAscScrollViewabilityDebug" … --- ## [Transform -\> Convert Field Type fails if my input is an "On"/"Off" string](https://community.grafana.com/t/transform-convert-field-type-fails-if-my-input-is-an-on-off-string/134398)
**Author:** [@greiginsydney](https://community.grafana.com/u/greiginsydney)\ **Replies:** 10\ **Last updated:** [October 17, 2024, 10:43am UTC](https://community.grafana.com/t/transform-convert-field-type-fails-if-my-input-is-an-on-off-string/134398 "2024-10-17T10:43:27Z")
What Grafana version and what operating system are you using? Grafana v11.2.2 on a Raspberry Pi 5 Bookworm. Data source is InfluxDB on the same Pi. What are you trying to achieve? Ultimately a “logic analyser” time … --- ## [Show amount of rain fall per hour](https://community.grafana.com/t/show-amount-of-rain-fall-per-hour/134257)
**Author:** [@info90f4](https://community.grafana.com/u/info90f4)\ **Replies:** 1\ **Last updated:** [October 15, 2024, 3:07pm UTC](https://community.grafana.com/t/show-amount-of-rain-fall-per-hour/134257 "2024-10-15T15:07:03Z")
Here is the situation: I have a rain sensor that sends every 10 minutes the total amount of rain fall it has seen. I do some calculations and write the amount of rain fall (in mm, which is 1l rain per m²) from the last… --- ## [influxDB.How to display today's and yesterday’s data on the same panel?](https://community.grafana.com/t/influxdb-how-to-display-todays-and-yesterday-s-data-on-the-same-panel/133637)
**Author:** [@thefatal](https://community.grafana.com/u/thefatal)\ **Replies:** 3\ **Last updated:** [October 8, 2024, 3:37am UTC](https://community.grafana.com/t/influxdb-how-to-display-todays-and-yesterday-s-data-on-the-same-panel/133637 "2024-10-08T03:37:06Z")
Im using grafana + influxdb, to show data collecting every minute, how can i show yesterday’s data from the same time on the same pannel ? for today’s data im using the query SELECT mean("value") FROM "stal\_soc" WHERE $t… --- ## [Gauge disappers when value to show is 0](https://community.grafana.com/t/gauge-disappers-when-value-to-show-is-0/128915)
**Author:** [@info90f4](https://community.grafana.com/u/info90f4)\ **Replies:** 3\ **Last updated:** [September 8, 2024, 9:12pm UTC](https://community.grafana.com/t/gauge-disappers-when-value-to-show-is-0/128915 "2024-09-08T21:12:50Z")
Hi experts, I created a Gauge visualization with 2 queries, hence I have two Gauges side by side (if screen size allows), which is fine. The gauges monitors incoming data from different sensors. I count the incoming da… --- ## [Leverage Timestamps to identify time spent in state, summarize daiy](https://community.grafana.com/t/leverage-timestamps-to-identify-time-spent-in-state-summarize-daiy/128907)
**Author:** [@flyfishutah](https://community.grafana.com/u/flyfishutah)\ **Replies:** 1\ **Last updated:** [August 19, 2024, 9:26am UTC](https://community.grafana.com/t/leverage-timestamps-to-identify-time-spent-in-state-summarize-daiy/128907 "2024-08-19T09:26:51Z")
Background - Using Home Assistant to control my Nest Thermostat, which events are written to an InfluxDB. One event is under domainID = climate is hvac\_action\_str. The data in this table appears like: “Time”,“hvac\_a… --- ## [Comparing string date fields in Influxql](https://community.grafana.com/t/comparing-string-date-fields-in-influxql/126656)
**Author:** [@x3la](https://community.grafana.com/u/x3la)\ **Replies:** 4\ **Last updated:** [July 21, 2024, 12:24pm UTC](https://community.grafana.com/t/comparing-string-date-fields-in-influxql/126656 "2024-07-21T12:24:51Z")
Grafana: 10.0.2 InfluxDB: 1.8.10-1 OS: Ubuntu I hope this is the correct place to ask. Apologies if not. I am trying to query data from InfluxDB in Grafana ‘Explore’ in influxql. I would like to compare a string fie… --- ## [Loading issue in grafana dashboard](https://community.grafana.com/t/loading-issue-in-grafana-dashboard/117811)
**Author:** [@laddu](https://community.grafana.com/u/laddu)\ **Replies:** 0\ **Last updated:** [March 25, 2024, 10:29am UTC](https://community.grafana.com/t/loading-issue-in-grafana-dashboard/117811 "2024-03-25T10:29:38Z")
Hi Team, I am using grafana v8.1.0 with influx DB v2.3. Through influx queries I’m trying to fetch the data for last 4 days. As I have almost 3.2L data for one day. Approximately, for four days it may go around 12L. But… --- ## [Diplaying the top N series for a specific metric](https://community.grafana.com/t/diplaying-the-top-n-series-for-a-specific-metric/115322)
**Author:** [@gpineda80](https://community.grafana.com/u/gpineda80)\ **Replies:** 0\ **Last updated:** [February 24, 2024, 6:01am UTC](https://community.grafana.com/t/diplaying-the-top-n-series-for-a-specific-metric/115322 "2024-02-24T06:01:00Z")
Using latest grafana OSS with influxDB 2.0. Testing influxDB as a possible replacement for our existing graphite backed setup. Having a had time trying to query the data to display in our grafana dashboards the same way… --- ## [Alerting with influxQL using variables](https://community.grafana.com/t/alerting-with-influxql-using-variables/114918)
**Author:** [@codi639](https://community.grafana.com/u/codi639)\ **Replies:** 8\ **Last updated:** [February 21, 2024, 11:36am UTC](https://community.grafana.com/t/alerting-with-influxql-using-variables/114918 "2024-02-21T11:36:02Z")
I’ve read this topics, which is giving a lot of good advice, but using the Flux language. Is there a way to create alerts with influxQL? I’m a neewbie and, although I can create alerts with simple queries, I can’t get … --- ## [Alert when multidimensional timeserie do not include data in past two weeks](https://community.grafana.com/t/alert-when-multidimensional-timeserie-do-not-include-data-in-past-two-weeks/114039)
**Author:** [@juhoarvid](https://community.grafana.com/u/juhoarvid)\ **Replies:** 0\ **Last updated:** [February 8, 2024, 12:11pm UTC](https://community.grafana.com/t/alert-when-multidimensional-timeserie-do-not-include-data-in-past-two-weeks/114039 "2024-02-08T12:11:23Z")
I would like to ensure that a value with specific tags exists at least during the last two-week period. I ended up giving up on doing this in one InfluxQL query. However, I found that it would be possible(in theory) by d… --- ## [Dealing with 0s in TimeSeries](https://community.grafana.com/t/dealing-with-0s-in-timeseries/111118)
**Author:** [@ajetsharwin](https://community.grafana.com/u/ajetsharwin)\ **Replies:** 0\ **Last updated:** [January 2, 2024, 5:21pm UTC](https://community.grafana.com/t/dealing-with-0s-in-timeseries/111118 "2024-01-02T17:21:04Z")
Hi Team, In the below image you can see an example time series where the data starts from a non-zero value —\> goes to zero —\> after four days, goes back to something non zero. Chart 1 Chart 1 however is super decep… --- ## [Dashboard subquery help](https://community.grafana.com/t/dashboard-subquery-help/111007)
**Author:** [@linuxd234](https://community.grafana.com/u/linuxd234)\ **Replies:** 8\ **Last updated:** [January 2, 2024, 6:12pm UTC](https://community.grafana.com/t/dashboard-subquery-help/111007 "2024-01-02T18:12:48Z")
I’m having a problem writing an influx query statement in the grafana dashboard, is it because there something wrong with my query statement or grafana-dashboard doesn’t support subqueries? my query: SELECT count(“c… --- ## [Group daily values by month to align with utility bill](https://community.grafana.com/t/group-daily-values-by-month-to-align-with-utility-bill/110949)
**Author:** [@poldim](https://community.grafana.com/u/poldim)\ **Replies:** 1\ **Last updated:** [December 29, 2023, 6:23pm UTC](https://community.grafana.com/t/group-daily-values-by-month-to-align-with-utility-bill/110949 "2023-12-29T18:23:18Z")
I’m trying to group my daily gas usage to reflect what is shown in my monthly utility bills which cycle starts on the 13th of most months What Grafana version and what operating system are you using? containerized at g… --- ## [Trouble with the WHERE field in Dashboard Query](https://community.grafana.com/t/trouble-with-the-where-field-in-dashboard-query/92034)
**Author:** [@nick4275](https://community.grafana.com/u/nick4275)\ **Replies:** 3\ **Last updated:** [December 17, 2023, 12:15pm UTC](https://community.grafana.com/t/trouble-with-the-where-field-in-dashboard-query/92034 "2023-12-17T12:15:50Z")
Defo a noob here but with a decent IT background. Any help gratefully received ! Having real trouble with my first Grafana Dashboard. Just can’t get it working at all ! My setup is within Home Assistant so I’m using th… [Next page](https://community.grafana.com/tag/influxql/279.md?match_all_tags=true&page=1&tags%5B%5D=influxql)