Forum Discussion
Cumulative count over time
Hey, I need to standardize my data. I get at irregular intervals a value for my devices. Message is sent when status changes. Here is an example data and what I mean by standardizing. In this exa...
Hey,
I do not want the sum of the values. Instead the cumulative distinct count of devices that have sent a value of 1. So I want to know how many devices have a value of 1 at each time interval. Sometimes the device sents the value at the interval, but sometimes it has sent the message right before the interval so I need to take that into account somehow.
Thank you for helping out!
Best,
Ike