Query data between range of values
Hello,
I have data in a bucket ranging with values between 100-150. In my analysis I would like to query the largest data point between two time periods, BUT I only want the largest data values between 100-120 not 100-150. For example; if the max value is 145 in the bucket for the time period I want to ignore it and find the value that is closest to 120 but not more than 120.
Here is my current code that does not work. How can I fix to work?
const [maxValue2] = await device.getData({ variable: 'rpms', query: 'max', start_date: startOfYesterday, end_date: endOfYesterday, filter: {operator: '<', value: 120}});