I am trying to extract data from a table. My table includes air quality data from a number of sensors and I want to compare the results for when a filter was on or off.
The table headings and a line of sample data is shown below.
'Date_Time' , 'PM2.5', 'UV_BC', 'Blue_BC', 'Green_BC', 'Red_BC', 'IR_BC', 'Particle_Count' , 'Particle_Conc', 'Filter_on_off'
09-10-2019 10:50:00 3 538 398.300 364.9 375.5 935.6 155.4708 51.9907 0
The 'Filter_on_off' value ranges from 0 to 1 but is not a logistical value, values of 0.5 and 0.75 are possible (related to fan speed)
How would I isolate data when the filter is off ('Filter_on_off' = 0) and on ('Filter_on_off' >1) for comparison?