• State Not Answered
  • Replies 1 reply
  • Subscribers 3 subscribers
  • Views 234 views
  • Users 0 members are here
Options
Related

Suspicious behavior of NumOfChanges function

YuiKawa

I use the following formula to detect the number of value changes.

NumOfChanges("count", "*-1d", "*")

 

In the attached data, NumOfChanges on 10/28/2023 12:14:41 was 27. However, I believe 28 is correct.

 

What is the calculation for such data?

Is the initial 0 => 1 not counted?

 

Please tell me!

Parents
  • 0

    Hello, I agree that 28 should be the correct result.

    I'm wondering if it's possible that the NumOfChanges function is either doing some kind of interpolation or taking the inside value at the start and endpoints of the interval.

     

    Is your tag stepped? If not, changing it into stepped might give you the result you expect.

    Or if you have verified that the function always counts one less than expected you could add a "+1" to the expression.

Reply
  • 0

    Hello, I agree that 28 should be the correct result.

    I'm wondering if it's possible that the NumOfChanges function is either doing some kind of interpolation or taking the inside value at the start and endpoints of the interval.

     

    Is your tag stepped? If not, changing it into stepped might give you the result you expect.

    Or if you have verified that the function always counts one less than expected you could add a "+1" to the expression.

Children
No Data