Bar charts with wrong monthly interval

[Norb1204]

There are shiftings when looking at a longer period of time with values that were created at the end of the month (with Flot this works).
Since a month has between 28 and 31 days, this does not work here with the intervals that are probably set to 30 days in the Auto setting.

Sample values for testing:
timestamp, value
2021-12-31T22:58:00.200Z, 311310
2022-01-31T22:58:00.055Z, 326486
2022-02-28T22:58:00.046Z, 315371
2022-03-31T21:58:00.098Z, 306648
2022-04-30T21:58:00.046Z, 284649
2022-05-31T21:58:00.051Z, 280660
2022-06-30T21:58:00.079Z, 261538
2022-07-31T21:58:00.044Z, 223407
2022-08-31T21:58:00.175Z, 233983
2022-09-30T21:58:00.105Z, 191090
2022-10-31T22:58:00.032Z, 256817
2022-11-30T22:58:00.180Z, 267888
2022-12-31T22:58:00.076Z, 277355
2023-01-31T22:58:00.042Z, 300691
2023-02-28T22:58:00.376Z, 209572
2023-03-31T21:58:00.051Z, 262541
2023-04-30T21:58:00.313Z, 463820
2023-05-31T21:58:00.115Z, 438150
2023-06-30T21:58:00.335Z, 439927
2023-07-31T21:58:00.136Z, 41002

For the month August, you can see the shift in the hover details (data from 07/31/2023, hover details from 08/22/2023).
The months in the X-axis are shown incorrectly (e.g. 0.2022).
I also cannot zoom or scroll a bar chart.

I noticed that everything is generally shifted. Data at the end of an hour, day or month will be displayed in the next hour, day or month. I assume that there is a common problem.

I hope I was able to describe the problem properly.

BR
Norbert

[neopholus]

I have exactly the same issue. I am logging the reading of my gas meter.

Based on this data, I want to create a bar chart showing the difference of the data:

Issue 1: When I configure the time to "end of this month" (should be end of October) and 6 month to show, the diagram ends next month (November):

Issue 2: As Norbert wrote before, the bars do not correspond to a month, but a 30 day period. Thus, as month have between 28 and 31 days, some days are shifted between the month and the result is wrong.

Example 1: When hovering over the May bar, the data shown corresponds to the May 31, which is correct:

Example 2: June also correctly corresponds to June 30:

Example 3: July incorrectly refers to July 30 (should be July 31):

Example 4, jumping to September, the data is only accumulated in the September bar until September 28:

Instead of 30-day-intervals, the aggregation must be done on a monthly basis.
I am a beginner here, but I assume, that can be done by data transformation described here