Datapoint for day N linked to the previous day date in tooltips

  • What Grafana version and what operating system are you using?

Grafana: 9.3
OS: RHEL 8.7

  • What are you trying to achieve?
    I want to display the evolution of the number of rows in a mysql table day by day.

  • How are you trying to achieve it?
    I am using a time series panel, with the following query:
    SELECT $__timeGroup(Timestamp, '1d') as time,COUNT(Timestamp) as 'All' FROM reportdb.Compliance GROUP BY $__timeGroup(Timestamp, '1d');

Timestamp is a date field in the table.

  • What happened?
    In the tool tips displayed, when hovering on a data point, the date is the date of the timestamp field - 1 day (e.g.: Timestamp = ‘2023-03-10’, value displayed in the tool tip = ‘2023-03-09’).

  • What did you expect to happen?
    The date for the data point must correspond to the date in the timestamp field.

  • Can you copy/paste the configuration(s) that you are having problems with?
    Details of the installed grafana package:

Installed Packages
Name : grafana-enterprise
Version : 9.3.6
Release : 1
Architecture : x86_64
Size : 304 M
Source : grafana-enterprise-9.3.6-1.src.rpm
Repository : @System
From repo : gcloud_Grafana_Grafana_8_x
Summary : Grafana
License : unknown
Description : Grafana

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    No error found or received.

  • Did you follow any online instructions? If so, what is the URL?