Last minute of data

Question & Answer
, ,
7

Hi @mikkel1 ,

Have tried to create a sample solution. Please check the second table and the calculated fields created.
sample solution 40403

Let me know if the requirement was interpreted incorrectly. A quick rundown of the sample solutions is:

  1. Created nearest minute timestamp against time field
  2. calculate latest minute for each id
  3. check deviation for latest minute only
  4. calculate deviation occurrence / total response times to check 50% threshold, allot moving, not moving flag

Thanks,
Prantika