Forum Discussion
Cumulative count over time
Hi Ikeumlaut,
One concern:
How to group those time values based on 10 min interval?
Why is 10:11 for 10A matched with 10:18 for 20B? Why should these two values belong to 10:10? While 10:14 for 10A and 10:18 for 10A belong to 10:20 and 10:30 section.
Best regards,
Yuliana Gu
Hey v-yulgu-msft
sorry, that is a mistake on the chart. I edited my post and it messed up it. So the grouping is:
- 10:00
- 10:11, 10:14, 10:18
Best,
Ike
Hi Ikeumlaut,
I am still confused about this calculation. That case, the Cumulative value for "28.3.18 10:10" in result table should be 2 rather than 1. Also, the Cumulative value for "28.3.18 10:20" in result table should be 0.
Regards,
Yuliana Gu
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