Show changes based on previous value of fields

[RobinP]

Hi All,

I am trying to produce a "Change Event" within a visualisation.

I have some data which is a list of ~50 parameters, each parameter has an Open (1) or Closed (0) value which is logged every 5ish seconds.

I want to look at 6 of the ~50 parameters, and if any of the specified parameters has changed it's value, then make a new measure show a value =/ 0

I've tried this using set analysis and above() function but haven't had any joy trying to combine the two.

My data looks something like this.

Timestamp	Open/Closed	Parameter
2020-01-22 08:50:41	0.0	27
2020-01-22 08:50:41	0.0	28
2020-01-22 08:50:41	0.0	29
2020-01-22 08:50:41	0.0	34
2020-01-22 08:50:41	0.0	35
2020-01-22 08:50:41	1.0	26
2020-01-22 08:50:52	0.0	27
2020-01-22 08:50:52	0.0	29
2020-01-22 08:50:52	1.0	26
2020-01-22 08:50:53	1.0	26
2020-01-22 08:50:57	0.0	27
2020-01-22 08:50:57	0.0	29
2020-01-22 08:50:57	1.0	26
2020-01-22 08:50:59	1.0	26
2020-01-22 08:51:03	0.0	27
2020-01-22 08:51:03	0.0	29
2020-01-22 08:51:03	1.0	26
2020-01-22 08:51:05	1.0	26
2020-01-22 08:51:09	0.0	27
2020-01-22 08:51:09	0.0	29
2020-01-22 08:51:09	1.0	26

Any advice appreciated.

Thanks

[anushree1]

Can you please provide the desired output for the shared sample input