Hi,
tried to create stacked bar charts for monthly or weekly using elasticseach as the origin of data
within the UI settings I used first day of the wek Monday,
Added to grafana.ini:
default_timezone = Europe/Berlin
default_week_start = monday ( in a second try Moday)
restarted grafana
did a transformation for time and set it to format: dd-WW
whatever I changed the x-axis showed Th-21 (for week 21) it never changed to Mo-21
counting the events manually it was always 1 week - thu till wen.
also tested differnt query options relative time or timeshift
like -4d or -4d -10W/W
or 0W/W 0d/W ..
nothing worked always stayed at Th.
In a second approach I used Monthly for a year.
at the beginning it looked promising, but after further analysis I found the following.
After reducing the data to this month only by adding: created_at:[2025-05-01 TO now]
Grafana showed still data in April (2 bars - April and May). As mentioned earlier manual search showed 220 events
counted May it showed 136 and April 84 - both together are the 220
Checked the x-axis and added DD to MM/YY and it showed: 12/05725
the complete row if you select last 6month:
13/11/24 13/12/24 12/01/25 12/01/24 11/02/25 13/03/25 12/04/25 12/05/25
and yes all events before 11 May were found in April and all beginning of the 12th in May..
also tested different Query options stays all the time the same. What can I do that Monthly starts at 1st of the month and weekly on Monday?
Grafana v12.0.0 (4c0e7045f9)