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 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