State timeline connect time range incorrect

Grafana
1

In the table, the time range for SUA-001-2330 is from 2025-04-24 06:52:09 to 2025-04-25 23:59:59.000, but the actual timeline ends only at 2025-04-24 10:06:20, which is the start time of SUA-001-2331 column, this is obviously incorrect.

How to set the SUA-001-2330 end timeline to 2025-04-25 23:59:59.000?

Grafana version:11.6.1

The table view like behind

image
image1615×893 82.1 KB

The timeline like behind
image
image1623×913 97 KB

2

Step 1: Make each timeline label unique per row

If you have duplicate labels (like multiple rows with SUA-001-2330), Grafana merges or splits them.

Modify your PostgreSQL query like this:

SELECT
  atime,
  btime,
  CONCAT(device_id, ' ', atime) AS label
FROM your_table

This will make the label like SUA-001-2330 2025-04-24 06:52:09, so Grafana treats each as a separate block.

Step 2: Update panel settings

In the right-side panel settings:

  • Turn off Merge equal consecutive values
  • Set Connect null values → Never
  • Set Show values → Always
  • Optional: Adjust Row height, Fill opacity, and Line width as needed

Step 3: Transformations in Grafana

In the Transformations tab:

  • Keep your current Convert field type
  • Add Organize fields:
    • Keep only: Atime, Btime, label
  • (Optional) Rename label to something meaningful like Status