From your data 2020-09-28T15:18:40Z duration=8.0 somevalue=42 otherfield=A 2020-09-28T15:18:45Z duration=2.0 somevalue=10 otherfield=B 2020-09-28T15:18:44Z duration=2.0 somevalue=10 otherfield=B We would add a column for the number of rows needed Time Duration somevalue otherfield rows 2020-09-28T15:18:40Z 8.0 42 A 8 2020-09-28T15:18:45Z 2.0 10 B 10 2020-09-28T15:18:44Z 2.0 10 B 12 Then we put a row at the start Time Duration somevalue otherfield rows 1 2020-09-28T15:18:40Z 8.0 42 A 8 2020-09-28T15:18:45Z 2.0 10 B 10 2020-09-28T15:18:44Z 2.0 10 B 12 makecontinuous when applied to field rows expands this to Time Duration somevalue otherfield rows 1 2 3 4 5 6 7 2020-09-28T15:18:40Z 8.0 42 A 8 9 2020-09-28T15:18:45Z 2.0 10 B 10 11 2020-09-28T15:18:44Z 2.0 10 B 12 We can then copy the relevant data up (well down after we sort descending on rows) We also adjust the time field so that in increases over the relevant duration Time Duration somevalue otherfield rows 2020-09-28T15:18:40Z 8.0 42 A 1 2020-09-28T15:18:41Z 8.0 42 A 2 2020-09-28T15:18:42Z 8.0 42 A 3 2020-09-28T15:18:43Z 8.0 42 A 4 2020-09-28T15:18:44Z 8.0 42 A 5 2020-09-28T15:18:45Z 8.0 42 A 6 2020-09-28T15:18:46Z 8.0 42 A 7 2020-09-28T15:18:47Z 8.0 42 A 8 2020-09-28T15:18:45Z 2.0 10 B 9 2020-09-28T15:18:46Z 2.0 10 B 10 2020-09-28T15:18:44Z 2.0 10 B 11 2020-09-28T15:18:45Z 2.0 10 B 12 You now have the data you need to count by time, somevalue, otherfield
... View more