Visualizing relative time data on Graph panel

Grafana Time Series Panel
1

Hi,

I’m using Grafana to visualize data gathered by a telemetry system.

We record time in miliseconds as relative values in the database. I would like Graph plugin to show the data as Time Series, as a continuous line (not bars), and to be able to show graph of one query on top of others for easy comparison.
My initial idea is to somehow modify the Graph plugin or datasource plugin to add the relative time to absolute time value (eg. from now() SQL function), but perhaps that’s not an ideal solution.

What is the best way to show such data in Grafana?

2

Hi,

I’ve found a way to show relative data on Graph panel.
I’m not sure if that’s the best way to do it, but more or less it works, I had to write SQL Query to return timestamp and add an interval:

(now() - interval '5 hours' + (ROW_NUMBER() OVER(ORDER BY basic_tick)) * interval '10 minutes') as time,

Hope it helps someone.

Best regards,
Aga