Grafana 7 - Stat panel - Time of last point

[cicciopizza]

When migrate Singlestat panel to new Stat panel, I can’t find the “Time of last point” option in view anymore.
Ver. 6.3.6:

Ver 7.0 (I can’t find Time of last point)

[bolausson]

I have the same issue with Grafana 7.0 and the fact that “Time of last point” option is missing in the new single stats plugin.

single-stat before migration:

single-stat after migration

[cicciopizza]

Another difference in the background:

It’s not very serious, but you could put an option to choose between the 2 modes.
If it is too complicated I think the display of version 6.3.6 is much better.

[cmtk]

I ran into this too.
Is there a way to do “Time of last point” with the new Singlestat panel, or with transforms, or has this functionality been lost?

[cicciopizza]

I tried everything that came to my mind but I couldn’t get the “time of last point”

Unfortunately for me this is strongly blocking

There are other minor issues as well, but this prevents me from upgrading to grafana 7

[nudelmann]

I struggled with this too and somehow came up with a solution (using mysql and grafana 7.0.3).
This only works for Table Series though, in Time Series the Time value is rigorously ignored- I dont know whats going on there.
My DB field is of type datetime and I just save the mysql current_timestamp().

In Grafana I select the column and cast $__time(), then override unit as From now.

Here is an example using the query-builder, Ive also tested with raw sql which also works fine:

[anhhuy2591]

I solved this by using Value “Last” and adding “relative time” (with value “5m” = last 5 minutes) to “Query options” (Query and transform data | Grafana documentation) since I want to display current/latest value only (regardless the selected time frame).

[diegoserrano]

There is official solution to this ?

[amandus99]

I would like to have a timestamp as well to see when the last update of data happened

[torkel]

Select the time field if you want to display the time of last data point

[matteocrc]

Hi,
this is my situation:

In my DB I have:

time value
1600773900000000000 1600773900
1600774200000000000 1600774200

And I want to show “X minutes ago” using “value” field.
I’m using the latest version of Grafana.
What am I doing wrong?
Thanks

[pepllu]

Is there a way we can see the time between “now” and “time of last value” on Grafana 7?

Thanks