Unique Value in Table

Grafana Graphite
1

Hi Folks,

Very new to Grafana, and my first post on this forum

I have data with a timestamp and an associated value, this value change only every hour or so, sometime is it 5 minutes, some other time 40 minutes.

I’m trying to show a table, with only the data when it changes, any idea ?

as an example:
Timestamp Data
2018-02-08 10:00am 10
2018-02-08 10:01am 10
2018-02-08 10:02am 10
2018-02-08 10:03am 12
2018-02-08 10:04am 12
2018-02-08 10:05am 12
2018-02-08 10:06am 12
2018-02-08 10:07am 16
2018-02-08 10:08am 16
2018-02-08 10:09am 15

I’d like to see only
Timestamp Data
2018-02-08 10:00am 10
2018-02-08 10:03am 12
2018-02-08 10:07am 16
2018-02-08 10:09am 15

Hope it makes sense, and possible
Thanks in advance for your help

2

Sounds like you need the derivative function or nonNegativeDerivative function or the perSecond function.

3

distinct() should do