Create Continuous Query that only keeps points where a value changed

influxdb

#1

How can I create a continuous query that only keeps points where a value changed?

Say I have this data

|time |IsRunning|Machine|
|1/22/2019 21:18|FALSE|Z-1-8|
|1/22/2019 21:18|FALSE|Z-1-8|
|1/22/2019 21:18|FALSE|Z-1-8|
|1/22/2019 21:18|FALSE|Z-1-8|
|1/22/2019 21:18|FALSE|Z-1-8|
|1/22/2019 21:19|FALSE|Z-1-8|
|1/22/2019 21:19|FALSE|Z-1-8|
|1/22/2019 21:19|FALSE|Z-1-8|
|1/22/2019 21:19|FALSE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|FALSE|Z-1-8|
|1/22/2019 21:19|FALSE|Z-1-8|
|1/22/2019 21:19|FALSE|Z-1-8|
|1/22/2019 21:19|FALSE|Z-1-8|
|1/22/2019 21:19|FALSE|Z-1-8|
|1/22/2019 21:19|FALSE|Z-1-8|
|1/22/2019 21:19|FALSE|Z-1-8|
|1/22/2019 21:19|FALSE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|

I want to continuously transform it to this

|time |IsRunning|Machine|
|1/22/2019 21:18|FALSE |Z-1-8|
|1/22/2019 21:19|TRUE |Z-1-8|
|1/22/2019 21:19|FALSE |Z-1-8|
|1/22/2019 21:19|TRUE |Z-1-8|