Hi Experts,
We have a data in following format
measure:{ name:"",value:"",timestamp:""} now type of value can be vary based on the name example as follows
measure:{name:co2,value:1,timestamp}
measure:{name:co2,value:2,timestamp}
measure:{name:co2,value:.1,timestamp}
measure:{name:o2,value:10,timestamp}
measure:{name:o2,value:11,timestamp}
measure:{name:o2,value:1,timestamp}
measure:{name:k+,value:upper,timestamp}
measure:{name:k+,value:lower,timestamp}
now i want to select co2 and 02 with co2 value between 5 and 10 and 02 with value
between 5 and 11
please help on how to formulate the filter query for the same
Thanks,
Tijo