For the below table, 26th row, count should be 8 because there is different Mac_ID inbetween. | streamstats count(eval(Mac_ID=="Serial num")) as Inspection_Count Query which I have written is, if serial number followed by mac_id then count should be calculated. But here in 26th row, there is no serial number so the count is continuing. How can I change if mac_Id changes inbetween when there is no serial number. Sno _time Device_ID Mac_ID Inspection_Count 1 2018-05-31T03:24:57.182+05:30 10 Started 1 2 2018-05-31T03:24:57.182+05:30 10 Serialnum 1 3 2018-05-31T03:24:58.869+05:30 10 5102 1 4 2018-05-31T03:25:09.179+05:30 10 5102 1 5 2018-05-31T06:23:23.446+05:30 10 Started 2 6 2018-05-31T06:23:23.446+05:30 10 Serialnum 2 7 2018-05-31T06:23:24.608+05:30 10 5102 2 8 2018-05-31T06:40:46.619+05:30 10 Started 3 9 2018-05-31T06:40:46.619+05:30 10 Serialnum 3 10 2018-05-31T06:46:59.594+05:30 10 5102 3 11 2018-05-31T06:47:00.084+05:30 10 5102 3 12 2018-05-31T06:47:03.098+05:30 10 5102 3 13 2018-05-31T06:58:30.714+05:30 10 Started 4 14 2018-05-31T06:58:30.714+05:30 10 Serialnum 4 15 2018-05-31T07:21:47.990+05:30 10 Started 5 16 2018-05-31T07:21:47.990+05:30 10 Serialnum 5 17 2018-05-31T07:22:09.677+05:30 10 5102 5 18 2018-05-31T07:22:10.063+05:30 10 5102 5 19 2018-05-31T07:22:11.070+05:30 10 5102 5 20 2018-09-05T10:30:13.455+05:30 86 Started 6 21 2018-09-05T10:30:13.455+05:30 86 Serialnum 6 22 2018-09-05T11:08:18.761+05:30 86 Started 7 23 2018-09-05T11:08:18.761+05:30 86 Serialnum 7 24 2018-09-05T11:08:41.907+05:30 86 7878 7 25 2018-09-05T11:08:42.071+05:30 86 7878 7 26 2018-09-05T11:09:04.068+05:30 86 8765 7 27 2018-09-05T11:09:26.877+05:30 86 8765 7 28 2018-09-05T11:09:41.845+05:30 86 8765 7 ... View more