Forum Discussion

Ikeumlaut's avatar
Ikeumlaut
Icon for Advocate I rankAdvocate 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
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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

  • Ikeumlaut's avatar
    Ikeumlaut
    Icon for Advocate I rankAdvocate I
    8 years ago

    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

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Icon for Microsoft Employee rankMicrosoft 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
        Icon for Advocate I rankAdvocate 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