Date when value is changed from 1 to 2 and reverse

Grafana Prometheus
1

Hi all

I am trying to create a stat panel which shows how much time is passed sence ifOperStatus is changed from 1 to 2 or reverse.

Ive try time() - timestamp(ifOperStatus{stuff, stuff}) and chose from Value Options Calculation - last* and Fields - time but it did not work as expected.

2

hello @zzozz which datasource you are using???

3

Prometheus.
Excuse me for missing this important fact

4

Hi, I think you need some changes() function around your series selector. Something like time() - timestamp(changes(ifOperStatus{stuff, stuff}[$__range]) > 0). Keep in mind Prometheus won’t return any data if the change happened outside the range of your query, so plan it accordingly :smiley:

5

I added your suggestion but still does not work as expected.
Again on every refresh it shows current date and time on the panel.

When, my query is ifOperStatus{stuff, stuff} and i change options > format: table and vizualization to Table im seeing this

image
image563×545 5.78 KB

When i change the query to your suggested method time() - timestamp(changes(ifOperStatus{ stuff, stuff}[$__range]) > 0) while in format: table im seeing this

image
image379×496 4.29 KB

and when i change visualization to stat respectively im seeing only 0 :smiley: