Log last Timestamp with label as name

Grafana Stat Panel
,
1

I recently started using Grafana via the Grafana Cloud Stack (I guess that makes it version 9.5.1?)

I am pushing my data to the provided Prometheus endpoint and everything works smoothly as expected expect for one thing which I am currently struggling to figure out how to solve it.

I want to log how long the last log of my devices is ago (in minutes). And as the title for each single display I want the name of my device which is provided inside the label.

For that I am using a Stat visualization. and query any of the metrics I expect from my devices and choose the following options for the Stat visualization:

  • Calculation: Last
  • Fields: Time
  • Unit: From Now

Everything else is left to its default value.

This works as expected but as the name I get “Time” for each of my devices and I can’t figure out how to select a the device name.

image
image1240×527 29.5 KB

Any help is appreciated

2

Welcome @phillipdiekmann to the Grafana forum.

Can you share what you have in these settings?

image
image508×647 27 KB

and also share your screen when the view is toggled to “Table view”?

image
image906×473 28.8 KB

3

Thanks @grant2 and cheers for your help.

Sure, those are my settings:

grafik

And this is the screen when toggled to “Table View”

grafik
grafik1298×469 15.5 KB

I found a workaround by sending the timestamp as a metric itself. This way I can make it look like I want:

grafik
grafik1706×1147 112 KB

However, I am still wondering how to achieve this without sending a dedicated metric for it.

4

What other choices besides Time are here? If there is a choice for Device, how does selecting that change your panel display?
image

Also, in Table View, I was expecting to see a dropdown whereby you could select the field (device name) being displayed. Is there indeed no dropdown?

image
image703×371 38.7 KB

5

These are the selections in the dropdown of the Table View:

grafik
grafik751×272 33.6 KB

The are the other choices:

grafik

I had a look at the response of the Query I am using and this is what it looks like for a single device:

grafik
grafik672×941 27.6 KB

The issue I see is that the field “Time” does not include the labels which are only listed for the field “Value”. Until now I wasn’t able to add the labels to the filed “Time” which I think could solve the issue

6

I am currently having the same issue, any solution yet?