https://community.developer.cybersource.com/t5/Integration-and-Testing/Get-the-difference-between-two-values-in-different-recordings/m-p/72241#M44603 <P class="_1qeIAgB0cPwnLhDF9XSiJM">I have multiple sensors and every value is recorded every 20S in my dB. Each recording has an ID, value, sensor id and timestamp. I would like to find an SQL request that would allow me to get the difference between the values reported by 2 sensors at near similar times. So for instance, for each value of sensor 5, I would like to get the difference with the closest value for sensor 5. Then I would like to also ensure that both values are not too far in time (20s for instance) and return a value only in that case.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">Would anyone have pointers or even a syntax to do this? I know influx is made for this stuff, but I know SQL only and don't yet understand nosql design so for now it's mysql.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">Thanks in advance for the help!</P> Fri, 19 Jun 2020 12:40:28 GMT MaxwellGael 2020-06-19T12:40:28Z https://community.developer.cybersource.com/t5/Integration-and-Testing/Get-the-difference-between-two-values-in-different-recordings/m-p/72241#M44603 <P class="_1qeIAgB0cPwnLhDF9XSiJM">I have multiple sensors and every value is recorded every 20S in my dB. Each recording has an ID, value, sensor id and timestamp. I would like to find an SQL request that would allow me to get the difference between the values reported by 2 sensors at near similar times. So for instance, for each value of sensor 5, I would like to get the difference with the closest value for sensor 5. Then I would like to also ensure that both values are not too far in time (20s for instance) and return a value only in that case.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">Would anyone have pointers or even a syntax to do this? I know influx is made for this stuff, but I know SQL only and don't yet understand nosql design so for now it's mysql.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">Thanks in advance for the help!</P> Fri, 19 Jun 2020 12:40:28 GMT https://community.developer.cybersource.com/t5/Integration-and-Testing/Get-the-difference-between-two-values-in-different-recordings/m-p/72241#M44603 MaxwellGael 2020-06-19T12:40:28Z https://community.developer.cybersource.com/t5/Integration-and-Testing/Get-the-difference-between-two-values-in-different-recordings/m-p/81926#M51643 <P>Every week, a couple of sensors fail. It's strange because it's close to the base, yet my farthest sensor has no issues.</P> Thu, 31 Mar 2022 16:17:29 GMT https://community.developer.cybersource.com/t5/Integration-and-Testing/Get-the-difference-between-two-values-in-different-recordings/m-p/81926#M51643 zeno93 2022-03-31T16:17:29Z