I am quite new to influx queries and I struggle with the syntax a lot. What I want to do is to get the data for only the first day of the month. I tried this: import “date” month = date.month() range(start: month) range(stop: month*+360000000000*24) from(bucket: “tasmota”) |> range(start: v.…

Hi @yves and welcome to the Influx Community Forum. This can indeed be a bit tricky. There may be better ways to handle this using Flux, but this should work. import "date" // The date package provides date and time constants and functions. firstDayOfMonth = date.truncate(t: now(), unit: 1mo) …

thank you very much! looks good, but I ran into a new problem with that code: error: record is missing label windowPeriod

Data from the first day of month

InfluxDB 2

grant1 October 6, 2024, 9:50am 4

Acc. to this post, that error is specific to Influx Data Explorer.

When I run a query in Grafana with the same general parameters for start and stop, and also aggregate using v.windowPeriod, it works.

Topic		Replies	Views
Query for current month in flux Welcome & Getting Started	6	10418	April 7, 2022
aggregateWindow for incomplete timeframes InfluxDB 2 influxdb	2	587	April 19, 2021
Monthly aggregation not working as expected InfluxDB 2 flux	3	669	January 10, 2022
Monthly usage based on daily cumulative values InfluxDB 2	3	569	November 4, 2022
Query at exact timestamp for different days Fluxlang influxdb	8	577	April 18, 2024

Data from the first day of month

Related topics