# \#flux **URL:** https://community.influxdata.com/tag/flux/39.md [Latest](https://community.influxdata.com/latest.md) · [Categories](https://community.influxdata.com/categories.md) · [Tags](https://community.influxdata.com/tags.md) --- ## [Error timezone.location](https://community.influxdata.com/t/error-timezone-location/58234)
**Author:** [@JeroenVH](https://community.influxdata.com/u/JeroenVH)\ **Replies:** 2\ **Last updated:** [September 15, 2026, 9:38am UTC](https://community.influxdata.com/t/error-timezone-location/58234 "2026-09-15T09:38:06Z")
I hava a task that has to create a daily total but I need to aggregate the totals in the local timezone. The task itself does not need to run in the local time zone, but the query needs to aggregate in the correct zone. … --- ## [Error while defining location parameter for aggregateWindow](https://community.influxdata.com/t/error-while-defining-location-parameter-for-aggregatewindow/24433)
**Author:** [@mutigozel](https://community.influxdata.com/u/mutigozel)\ **Replies:** 11\ **Last updated:** [June 29, 2026, 11:30pm UTC](https://community.influxdata.com/t/error-while-defining-location-parameter-for-aggregatewindow/24433 "2026-06-29T23:30:27Z")
Hi all, When I try to set location parameter in aggregateWindow parameters as below: |\> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false, location: "UTC") I get an error like: error @5:6-5:91: e… --- ## [How to parse multiple values from a single string field?](https://community.influxdata.com/t/how-to-parse-multiple-values-from-a-single-string-field/58383)
**Author:** [@dewi-ny-je](https://community.influxdata.com/u/dewi-ny-je)\ **Replies:** 3\ **Last updated:** [March 25, 2026, 8:35am UTC](https://community.influxdata.com/t/how-to-parse-multiple-values-from-a-single-string-field/58383 "2026-03-25T08:35:14Z")
Home Assistant provides day ahead electricity prices as attributes of the entity “current electricity price”, so in InfluxDB those values appear all together in the field “prices\_str” as string: (InfluxQL query for comp… --- ## [Plot the difference between two stream/data](https://community.influxdata.com/t/plot-the-difference-between-two-stream-data/58268)
**Author:** [@HarimbolaSantatra](https://community.influxdata.com/u/HarimbolaSantatra)\ **Replies:** 1\ **Last updated:** [February 21, 2026, 8:39pm UTC](https://community.influxdata.com/t/plot-the-difference-between-two-stream-data/58268 "2026-02-21T20:39:17Z")
I have a random data like this: The query that I used: data1 = from(bucket: "testBucket") |\> range(start: -3h) |\> ... |\> yield(name: "data1 ") data2 = from(bucket: "testBucket") |\> range(start: -3h) |\> ..… --- ## [How to delete values based on non-existence of a tag](https://community.influxdata.com/t/how-to-delete-values-based-on-non-existence-of-a-tag/22731)
**Author:** [@brimstone](https://community.influxdata.com/u/brimstone)\ **Replies:** 2\ **Last updated:** [January 29, 2026, 7:57pm UTC](https://community.influxdata.com/t/how-to-delete-values-based-on-non-existence-of-a-tag/22731 "2026-01-29T19:57:16Z")
I recently added a global tag to all my Telegraf instances to be able to determine which data is sent from which instance. I use one Telegraf instance per device being polled, so I set the key of the global tag to “devic… --- ## [Calculate Power Consumption on defined Periode with TAGS](https://community.influxdata.com/t/calculate-power-consumption-on-defined-periode-with-tags/57649)
**Author:** [@Franck\_Bellot](https://community.influxdata.com/u/Franck_Bellot)\ **Replies:** 4\ **Last updated:** [January 5, 2026, 7:20am UTC](https://community.influxdata.com/t/calculate-power-consumption-on-defined-periode-with-tags/57649 "2026-01-05T07:20:17Z")
Hello Team, I hope you’ll be able to help me, because I’m completely confused about getting the right calculation. I’d like to know the electricity power consumption of my equipment per day by mode. Okay, that sounds b… --- ## [Can't run two Checks on measurements of different types?](https://community.influxdata.com/t/cant-run-two-checks-on-measurements-of-different-types/58179)
**Author:** [@ianh98](https://community.influxdata.com/u/ianh98)\ **Replies:** 0\ **Last updated:** [December 16, 2025, 5:56pm UTC](https://community.influxdata.com/t/cant-run-two-checks-on-measurements-of-different-types/58179 "2025-12-16T17:56:45Z")
So I’m trying to get Checks working (InfluxDB V2), using the API to generate checks from a given flux query. All the API stuff works, what I’m running into is that I seemingly can’t have different checks running monitor… --- ## [Queries get bad response time and eventually timeout](https://community.influxdata.com/t/queries-get-bad-response-time-and-eventually-timeout/58122)
**Author:** [@Eloi\_Gabaldon](https://community.influxdata.com/u/Eloi_Gabaldon)\ **Replies:** 1\ **Last updated:** [November 26, 2025, 7:19pm UTC](https://community.influxdata.com/t/queries-get-bad-response-time-and-eventually-timeout/58122 "2025-11-26T19:19:26Z")
In my project we are storing several data from sensor belonging to buildings. Then we let te user select a set of buildings of his interest and perform a query to get the data. The data is stored in a simple format with… --- ## [Using opentelemetry histogram data written to influx](https://community.influxdata.com/t/using-opentelemetry-histogram-data-written-to-influx/58041)
**Author:** [@kevin0x90](https://community.influxdata.com/u/kevin0x90)\ **Replies:** 3\ **Last updated:** [October 30, 2025, 7:58pm UTC](https://community.influxdata.com/t/using-opentelemetry-histogram-data-written-to-influx/58041 "2025-10-30T19:58:14Z")
Hi, I have the following setup: an application using opentelemetry to record histogram values (request duration) this gets exported to a telegraf agent running the opentelemetry input service with prometheus\_v2 config… --- ## [Influxdb 2 stops when grafana query 500+ tag metrics simultaneously](https://community.influxdata.com/t/influxdb-2-stops-when-grafana-query-500-tag-metrics-simultaneously/58029)
**Author:** [@raja\_sekar](https://community.influxdata.com/u/raja_sekar)\ **Replies:** 1\ **Last updated:** [October 27, 2025, 1:36pm UTC](https://community.influxdata.com/t/influxdb-2-stops-when-grafana-query-500-tag-metrics-simultaneously/58029 "2025-10-27T13:36:01Z")
I have influxdb2-2.7.11-windows running with 3000+ tags loaded by telegraf which pulls data from opcua server. Grafana V12.0.0 running in ubuntu server has 500+ stat panels using fluxql for the influxdb datasource. The p… --- ## [Flux and grafana](https://community.influxdata.com/t/flux-and-grafana/58024)
**Author:** [@pluto\_mars](https://community.influxdata.com/u/pluto_mars)\ **Replies:** 1\ **Last updated:** [October 23, 2025, 10:05am UTC](https://community.influxdata.com/t/flux-and-grafana/58024 "2025-10-23T10:05:08Z")
I am using influxdb 2.7.1 with Grafana 9.4.7. Suppose I have the following in my influxdb: In bucket “A” → “\_measurement” = “meas\_1” with “\_field” = “a”, “b” and “c” In bucket “A” → “\_measurement” = “meas\_2” with “\_fi… --- ## [InfluxDB v2 Deadlock or Disk Issues](https://community.influxdata.com/t/influxdb-v2-deadlock-or-disk-issues/57929)
**Author:** [@ticchioned](https://community.influxdata.com/u/ticchioned)\ **Replies:** 5\ **Last updated:** [October 9, 2025, 10:30am UTC](https://community.influxdata.com/t/influxdb-v2-deadlock-or-disk-issues/57929 "2025-10-09T10:30:29Z")
I am using a v2.7.12 InfluxDB server and experiencing a deadlock very similar to this bug, which was supposedly fixed in v2.7.12: Possible Deadlock in TagValueIterator() and AddSeriesList() · Issue #26164 · influxdata/in… --- ## [Querying Latest 50 Records When Recent Data Time is Unknown](https://community.influxdata.com/t/querying-latest-50-records-when-recent-data-time-is-unknown/57858)
**Author:** [@shijianoo](https://community.influxdata.com/u/shijianoo)\ **Replies:** 3\ **Last updated:** [August 28, 2025, 12:52pm UTC](https://community.influxdata.com/t/querying-latest-50-records-when-recent-data-time-is-unknown/57858 "2025-08-28T12:52:06Z")
How can I quickly query the latest 50 records from a bucket when I don’t know when the most recent data was inserted? The latest data could be from a day ago, a month ago, or even a year or two ago. --- ## [How to show "No Data" when no metrics since a long time](https://community.influxdata.com/t/how-to-show-no-data-when-no-metrics-since-a-long-time/31599)
**Author:** [@yaume](https://community.influxdata.com/u/yaume)\ **Replies:** 3\ **Last updated:** [August 26, 2025, 8:11am UTC](https://community.influxdata.com/t/how-to-show-no-data-when-no-metrics-since-a-long-time/31599 "2025-08-26T08:11:42Z")
Hi, To show the status of a connection , I use “http response” plugin. I use a “Stat” visualisation in my Grafana dashboard to display the status with a color and an associated text This is my flux request: from(buck… --- ## [What should be the strategy towards InfluxDb v3 with regards to Flux?](https://community.influxdata.com/t/what-should-be-the-strategy-towards-influxdb-v3-with-regards-to-flux/57217)
**Author:** [@donker](https://community.influxdata.com/u/donker)\ **Replies:** 3\ **Last updated:** [August 23, 2025, 7:47am UTC](https://community.influxdata.com/t/what-should-be-the-strategy-towards-influxdb-v3-with-regards-to-flux/57217 "2025-08-23T07:47:11Z")
I have convinced my client to move from MS SQL to InfluxDb for the project I am working on. This client now pays 100s per month for the cloud offering. As I am building out the project I stumble on “Flux now in maintenan… --- ## [Garbage performance for getting n amount of last elements from fields](https://community.influxdata.com/t/garbage-performance-for-getting-n-amount-of-last-elements-from-fields/57611)
**Author:** [@Adam\_Labus](https://community.influxdata.com/u/Adam_Labus)\ **Replies:** 4\ **Last updated:** [August 22, 2025, 11:15pm UTC](https://community.influxdata.com/t/garbage-performance-for-getting-n-amount-of-last-elements-from-fields/57611 "2025-08-22T23:15:45Z")
I am running Influx Cloud 2.0. I have a measurement where each field is a sensor posting data at differing intervals. For each field I want to get n amount of latest records. For one record the flux query is: from(buc… --- ## [How to efficiently query the latest data timestamp for pagination without knowing the data time range?](https://community.influxdata.com/t/how-to-efficiently-query-the-latest-data-timestamp-for-pagination-without-knowing-the-data-time-range/57830)
**Author:** [@shijianoo](https://community.influxdata.com/u/shijianoo)\ **Replies:** 2\ **Last updated:** [August 22, 2025, 1:21am UTC](https://community.influxdata.com/t/how-to-efficiently-query-the-latest-data-timestamp-for-pagination-without-knowing-the-data-time-range/57830 "2025-08-22T01:21:34Z")
I’m implementing a web frontend with pagination for InfluxDB data, but I’m facing a performance challenge when dealing with buckets that have unknown data time ranges. I’m using anchor-based pagination with the followin… --- ## [Accruing values after change of state](https://community.influxdata.com/t/accruing-values-after-change-of-state/57545)
**Author:** [@Patrick808](https://community.influxdata.com/u/Patrick808)\ **Replies:** 0\ **Last updated:** [July 4, 2025, 4:09pm UTC](https://community.influxdata.com/t/accruing-values-after-change-of-state/57545 "2025-07-04T16:09:38Z")
I’m trying to estimate battery state of charge given a switch from charging to discharging and the accumulated energy from that point. The resource was helpful in getting some ideas and learning about the monitor functi… --- ## [How to get spread between mean(top(n: X)) and mean(bottom(n: Y))?](https://community.influxdata.com/t/how-to-get-spread-between-mean-top-n-x-and-mean-bottom-n-y/57519)
**Author:** [@dewi-ny-je](https://community.influxdata.com/u/dewi-ny-je)\ **Replies:** 0\ **Last updated:** [July 1, 2025, 8:56am UTC](https://community.influxdata.com/t/how-to-get-spread-between-mean-top-n-x-and-mean-bottom-n-y/57519 "2025-07-01T08:56:58Z")
I am calculating the daily spread in energy prices. I would like, at the end, to get a single table with multiple data columns, where the spread is calculated on pure top and bottom, then top(2) and bottom(2) values, up … --- ## [Calculate difference in a InfluxDB task and avoid doubling of data](https://community.influxdata.com/t/calculate-difference-in-a-influxdb-task-and-avoid-doubling-of-data/57047)
**Author:** [@cortlieb](https://community.influxdata.com/u/cortlieb)\ **Replies:** 9\ **Last updated:** [June 30, 2025, 10:38am UTC](https://community.influxdata.com/t/calculate-difference-in-a-influxdb-task-and-avoid-doubling-of-data/57047 "2025-06-30T10:38:35Z")
I have a task that sounded easy in the beginning and turned out to be difficult. I have some rain sensors. The operation principle is that a small bucket is filled with water when it rains. When the bucket is full, it t… --- ## [Preferred query language moving forward](https://community.influxdata.com/t/preferred-query-language-moving-forward/57499)
**Author:** [@Adam\_Labus](https://community.influxdata.com/u/Adam_Labus)\ **Replies:** 1\ **Last updated:** [June 28, 2025, 1:08pm UTC](https://community.influxdata.com/t/preferred-query-language-moving-forward/57499 "2025-06-28T13:08:06Z")
I built my whole frontend app around Flux, thinking it to be the most future safe query language. Now with the version 3 rewrite, it’s support is dropped. Are queries better expressed in InfluxQL or in Flux? Which lang… --- ## [Http.post the whole table](https://community.influxdata.com/t/http-post-the-whole-table/22001)
**Author:** [@Nam\_Giang](https://community.influxdata.com/u/Nam_Giang)\ **Replies:** 7\ **Last updated:** [June 12, 2025, 12:33am UTC](https://community.influxdata.com/t/http-post-the-whole-table/22001 "2025-06-12T00:33:56Z")
Hi there, I’m looking at this link: Convert results to JSON and send them to a URL | InfluxDB OSS 2.0 Documentation, where a code excerpt is as follow: import "http" import "json" from(bucket: "noaa") |\> filter(fn: … --- ## [Update2.7.6 to 2.7.11+ Exception](https://community.influxdata.com/t/update2-7-6-to-2-7-11-exception/57405)
**Author:** [@john\_gogozilla](https://community.influxdata.com/u/john_gogozilla)\ **Replies:** 0\ **Last updated:** [June 11, 2025, 1:35am UTC](https://community.influxdata.com/t/update2-7-6-to-2-7-11-exception/57405 "2025-06-11T01:35:43Z")
the following Flux Script runs well in 2.7.6 but in 2.7.12 , it causes errors as following , why? Can someone tell me the difference between .6 and .12, I can not find Flux release notes ether. rangeData = from(bucket… --- ## [Removing a specific firmware type from a query/ Grafana alert](https://community.influxdata.com/t/removing-a-specific-firmware-type-from-a-query-grafana-alert/57372)
**Author:** [@Celeste](https://community.influxdata.com/u/Celeste)\ **Replies:** 6\ **Last updated:** [June 10, 2025, 9:52am UTC](https://community.influxdata.com/t/removing-a-specific-firmware-type-from-a-query-grafana-alert/57372 "2025-06-10T09:52:44Z")
Hi. I am using influx db 2 and coding in flux to make an alert in Grafana. I am trying to remove certain devices with certain firmwares from the alert. The firmware I need to remove has a -p at the end. I have tried so… --- ## [Strange type swapping in measurement](https://community.influxdata.com/t/strange-type-swapping-in-measurement/57310)
**Author:** [@hfi](https://community.influxdata.com/u/hfi)\ **Replies:** 13\ **Last updated:** [May 23, 2025, 10:33pm UTC](https://community.influxdata.com/t/strange-type-swapping-in-measurement/57310 "2025-05-23T22:33:47Z")
Hi, I’m new to influxdb and have a very strange behavior that I don’t understand, maybe someone can enlighten me: I have a python script (see some code below) that reads multiple sensors and inserts it to influxdb in se… --- ## [I need help on finding the minimum accross 2 fields](https://community.influxdata.com/t/i-need-help-on-finding-the-minimum-accross-2-fields/57292)
**Author:** [@hfi](https://community.influxdata.com/u/hfi)\ **Replies:** 1\ **Last updated:** [May 23, 2025, 5:53pm UTC](https://community.influxdata.com/t/i-need-help-on-finding-the-minimum-accross-2-fields/57292 "2025-05-23T17:53:58Z")
Hi. I’m new to influxdb and have to say the official docs on query functions are so abstract, that they are no help at all… I guess my problem is fairly easy but I can’t seem to find a solution. I have a measurement “… --- ## [Split 2 dimentional array from a \_value](https://community.influxdata.com/t/split-2-dimentional-array-from-a-value/57233)
**Author:** [@Jik](https://community.influxdata.com/u/Jik)\ **Replies:** 2\ **Last updated:** [May 19, 2025, 8:41am UTC](https://community.influxdata.com/t/split-2-dimentional-array-from-a-value/57233 "2025-05-19T08:41:51Z")
Hello everyone, I have a question about the flux language and how to seperate array data. For a task I’m creaing a flux script that needs to split a 2 dimentional array. This array is a string in the \_value column. For… --- ## [Performance issues after migration from InfluxDB 1.8 to 2.7](https://community.influxdata.com/t/performance-issues-after-migration-from-influxdb-1-8-to-2-7/57193)
**Author:** [@davide.avella](https://community.influxdata.com/u/davide.avella)\ **Replies:** 1\ **Last updated:** [May 14, 2025, 10:22pm UTC](https://community.influxdata.com/t/performance-issues-after-migration-from-influxdb-1-8-to-2-7/57193 "2025-05-14T22:22:55Z")
Hello, through a specific procedure, I migrated data from an InfluxDB 1.8 instance deployed on a VM to an InfluxDB 2.7 instance deployed on AKS. The database has very high cardinality. The data starts from 2023 and inc… --- ## [Flux help required](https://community.influxdata.com/t/flux-help-required/57164)
**Author:** [@sparkitny](https://community.influxdata.com/u/sparkitny)\ **Replies:** 2\ **Last updated:** [May 4, 2025, 8:53pm UTC](https://community.influxdata.com/t/flux-help-required/57164 "2025-05-04T20:53:43Z")
Hi, currently I’m struggling with joining two tables together. Maybe someone has an idea, as I’m driving crazy understanding the possibilities of flux. Suppose the following two tables: left = from(bucket: "pon") |\>… --- ## [Summing a value across all my devices while keeping the \_time column.](https://community.influxdata.com/t/summing-a-value-across-all-my-devices-while-keeping-the-time-column/57022)
**Author:** [@Celeste](https://community.influxdata.com/u/Celeste)\ **Replies:** 6\ **Last updated:** [April 29, 2025, 7:46pm UTC](https://community.influxdata.com/t/summing-a-value-across-all-my-devices-while-keeping-the-time-column/57022 "2025-04-29T19:46:41Z")
Hi, I am plotting on Grafana using flux. I am having trouble summing a value across all my devices while keeping the \_time column. For example, below is my working code for displaying battery state of charge. This disp… [Next page](https://community.influxdata.com/tag/flux/39.md?match_all_tags=true&page=1&tags%5B%5D=flux)