In the timeseries, I see wrong date when I hover over the values

[kavyarkolli]

What happened?

Every grouping in grafana is showing left edge value instead of actual grouping, for 2024-04 its showing 2024-03-31 19:00:00, and the same goes to every other month.
Here is the query I am using
SELECT
STR_TO_DATE(created_at, '%Y-%m') as time,manufacturer as metric,
sum(uuid_count)
FROM (
SELECT
created_at,manufacturer,
COUNT(uuid) AS uuid_count
FROM
storages_v2
WHERE
$__timeFilter(created_at) AND
deleted_at IS NULL
GROUP BY 1,2
ORDER BY 1
) AS subquery group by 1,2;

What did you expect to happen?

To show the actual date instead of previous day date

Did this work before?

I am a new user

How do we reproduce it?

Is the bug inside a dashboard panel?

No response

Environment (with versions)?

Grafana:
OS:
Browser:

Grafana platform?

None

Datasource(s)?

No response

[leeoniya]

please fill out the form. there is too much info missing here.

also, attach a debug snapshot: https://grafana.com/docs/grafana/latest/troubleshooting/send-panel-to-grafana-support

[grafanabot]

Thanks for creating this issue! We think it's missing some basic information.

Follow the issue template and add additional information that will help us replicate the problem.
For data visualization issues:

• Query results from the inspect drawer (data tab & query inspector)
• Panel settings can be extracted in the panel inspect drawer JSON tab

For dashboard related issues:

• Dashboard JSON can be found in the dashboard settings JSON model view

For authentication, provisioning and alerting issues, Grafana server logs are useful.

Happy graphing!