Forum Discussion

Ikeumlaut's avatar
Ikeumlaut
Advocate I
8 years ago

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...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

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

Ikeumlaut's avatar
Ikeumlaut
Advocate I
8 years ago

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

  • Ikeumlaut's avatar
    Ikeumlaut
    Advocate I
    8 years ago

    Hey v-yulgu-msft,

     

    here is a picture of what I'm looking for. Hope this explains it better.

     

     

    Best,

    Ike