Dear viewer,
I am running a Sql Server query to sum items per day as my Grafana graph input. It works well but does not seem to include todays data until we go past midnight. I attach images of the sql server query and Grafana’s output. Can anyone help me? I just need Grafana to display all data including todays.
Many thanks.
Welcome
What time zone is your date column? It needs to be converted to UTC
Hi yosiasz and thanks for the reply.
If you look at my query in the above images, you’ll see it returns a count grouped by date. e.g.
|2023-04-05|258|
|2023-04-04|862|
These dates are UTC although it should make no difference as I have stripped off time so that I can group by day. If you then look at my grafana chart image above, you can see it charts all data except todays. (Date of posting is 5th April 2023).
I have tried all sorts, I have tried concatenating a single second onto the data in sql server. I have tried various transformations in Grafana. No matter what I do, Grafana cuts off the chart at midnight of the previous day.
Can anyone help with this ?
