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

Question

I have recently set up Grafana with InfluxDB. I'd like to show a panel that indicates how long it has been since an event took place.

Examples:

• Server last reported in: 33 minutes ago
• Last user sign up: 17 minutes ago

I can get a single metric pretty easily with the following code:

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

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

Any suggestions?

Answer 1

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

1. GoTo the Options-Tab
2. Select Value -> Stat -> Time of last point
3. Select Value -> Stat -> Unit -> Date & time -> From Now