[Feature request] Show timestamp on SingleStat

[PaulGrimshaw]

We use Grafana for displaying weather measurements offshore. However these measurements commonly fall behind due to date collection issues. We show the latest recorded values using the SingleStat component, but what would be really useful is to see the timestamp that this value was recorded at, or even better a smart duration ("4min ago").

Our charts also show future data (forecasts) so it is hard to pick up whether the measurement has fallen behind or not.

Our datasource is influxdb

[inselbuch]

This is an excellent idea. And this could be implemented fairly easily. Where you can currently select the stat as "min,max,avg, etc." you could simply add another stat which is timestamp.

[aabrodskiy]

This would be awesome to have!

[geckogecko]

+1

[neilchalk]

+1

[royemmerich]

Being able to alert if the time difference is greater than a certain period would be great to have too.

[torkelo]

Implemented in #9298

You can now select "Time of last point" as Stat (ops there is no check that the last point is null, this needs to be filtered out in the query).

3 new unit date formats are available (no custom date formats)

[voiprodrigo]

Can this be used to define a threshold on the elapsed time since the time of the value?
I can use the From now date format, and that seems to translate fine, but I to have red/green/yellow depending on the number of seconds elapsed (now - time of value)

[inselbuch]

I played with that with limited success… it’s not clear what values you should use for the thresholds… should they be milliseconds? seconds? nanoseconds? Frank Inselbuch, President Unix Edge, Inc. 713-701-5421 Can this be used to define a threshold on the elapsed time since the time of the value? I can use the From now date format, and that seems to translate fine, but I to have red/green/yellow depending on the number of seconds elapsed (now - time of value) — You are receiving this because you commented. Reply to this email directly, view it on GitHub<#6710 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AVlReT9Fg512oeXGoGREl2_8slTbiQ5dks5s4K3WgaJpZM4K8Pqf>.

[alrghods]

+1

[vcandeau]

Hi,

Did you find some solution to get working threshold on (now - time of value)

Best regards,

[liamdiprose]

@vcandeau I think the plan is to rework the conditional formatting, which mentions support for "date and duration" values. #11418