How to show "33 minutes ago" on the Grafana dashboard with InfluxDB?

Question

I recently created Grafana with InfluxDB. I would like to show a panel that shows how much time has passed since the event.

Examples:

• Last server message: 33 minutes ago
• Last user subscribed: 17 minutes ago

I can easily get one metric with the following code:

SELECT time, last("duration") as last_duration FROM custom_events ORDER BY time DESC

But I can't get Grafana to do what I want with a time field.

Any suggestions?

Answer 1

Since Grafana (4.6.0) is now possible with singlestat panels.

• GoTo Options-Tab
• Select Value→ Stat→Time of last point
• Value → Stat → Unit → Date & time → From Now

Answer 2

(4.0.3) singlelestat. issue. , .