- What Grafana version and what operating system are you using?
Grafana V10.3.3 on AWS with data query to influxDB V2.
The local timezone is 6h ahead.
- What are you trying to achieve?
Using difference function to achieve daily, weekly, monthly energy value.
- How are you trying to achieve it?
See below for the details.
- What happened?
In daily, it’s missing the first hour. In weekly and monthly, it’s missing the first day.
Today
I have ajusted Relative time to be now/d
As you can see, although the time period for the data is from 00:00, it starts with 02:00 in the bar chart (well, I think, it’s the data period for 01:00 - 02:00, then I would rather to show 01:00 instead of 02:00. How to do this?) .
From the data query, it’s querying the data from 18:00 (1729706400000) (with 6h time difference, it will be 00:00 locally). (I am limited with only 5 screenshots when I tried to post it. Sorry for that.)
Where is the data for 00:00 - 01:00?
Yesterday
I have ajusted Time shift to be 0d/d (if I put 1d/d, it’s taking the data from the data before yesterday.)
Same issue as in today.
This week
I have ajusted Relative time to be now/w
And I have an Override inside it to show the date.
Field name Time with Unit time:MM-DD
As you can see, although the time period for the data is from 10-21 00:00, it starts with 10-22 in the bar chart (well, I think, it’s the data period for 10-21 to 10-22, then I would rather to show 10-21 instead of 10-22. How to do this?) .
From the data query, it’s querying the data from 10-20 18:00 (1729447200000) (with 6h time difference, it will be 10-21 00:00 locally)
But in the table view, it’s starting from 10-22 02:00. How come?
Last Week
I have ajusted Time shift to be 1w/w
Same situation. How to show first 6 days to be 10-14 to 10-19 instead of 10-15 to 10-20 as the last day is 10-20 (as the data query ends on 10-23 23:59:59)
This month
I have ajusted Relative time to be now/M
As you can see, although the time period for the data is from 10-01 00:00, it starts with 10-02 in the bar chart (well, I think, it’s the data period for 10-01 to 10-02, then I would rather to show 10-01 instead of 10-02. How to do this?) .
And I have an Override inside it to show the date. (same as above)
From the data query, it’s querying the data from 09-30 18:00 (1727719200000) (with 6h time difference, it will be 10-01 00:00 locally)
But in the table view, you can see, it’s same issue as above, it’s starting from 10-02 02:00. How come?
Great thanks in advance!
