Why does the month change for bar charts not on the 1st but on example the 18th of each month?

[pfaelzerbube]

Hi, I´m using Grafana in home assistant and my database is influxDB.
Hello,
I have created various evaluations in Grafana that show me monthly values using bar charts. The values are also correct.
However, my problem is that I only get the current month displayed from about the middle of a month and until then no bar is displayed for the current month. When I call up the corresponding helper in HA, the value is there correctly, but nothing is displayed in Grafana.
What could be the reason for this?

April is missing, why?

Here is the query:

So I expect maybe next week I will see the value for April, but why not today or in the last days.

Holger

[infofcc3]

Switch to Text Editor
use this query
SELECT
max(“value”)
FROM “kWh”
WHERE
“friendly_name” = ‘PV-Ertrag pro Monat’
AND $timeFilter
GROUP BY
time(30d)
fill(previous)

• $timeFilter: Grafana automatically replaces this with your dashboard’s time range.
• fill(previous): Tells InfluxDB to fill incomplete monthly buckets with the last known value (so the current month always appears).

[pfaelzerbube]

Thank you, but it has the same result:

[yosiasz]

if you click on query inspector what do you see?

[pfaelzerbube]

since yesterday, the April is visible. So maybe I habe to wait until May, I dont know

[grant2]

@pfaelzerbube

my problem is that I only get the current month displayed from about the middle of a month and until then no bar is displayed for the current month

Does putting 0M/M in the Time shift box of Query options make any difference in your graph?

[pfaelzerbube]

I don´t think there will be any difference, but actually I can´t test it, as I said in my post before.
I the past I did some testing with different option there, but nothing worked