2 Replies Latest reply: Dec 21, 2012 3:55 AM by Peter Rydén RSS

    Value occures over a time span

      Hi!

      Need some help to solve this problem.

      I have a table with ID, Date and Value, as below and I want to count as True every non-zero value if it occure for more than 5 minutes. e g the value 1 occure for more than 5 minutes between 2012-01-10 21:11:16 and 21:17:26 and once again between 21:21:36 and 21:29:20.

       

      IDDateValue
      343192012-01-10  21:09:430
      343192012-01-10  21:11:161
      343192012-01-10  21:12:181
      343192012-01-10  21:15:551
      343192012-01-10  21:17:261
      343192012-01-10  21:18:300
      343192012-01-10  21:21:361
      343192012-01-10  21:23:081
      343192012-01-10  21:24:411
      343192012-01-10  21:29:201
      343202012-01-10  22:08:510
      343202012-01-10  22:11:260
      343202012-01-10  22:14:012
      343202012-01-10  22:15:032
      343202012-01-10  22:18:392
      343202012-01-10  22:20:482
      343202012-01-10  22:23:231
      343202012-01-10 22:25:210
      343202012-01-10 22:26:181

       

      /Peter