I’ve got sensor readings in my data table. They’re in the range of zero to five.
I want to calculate the difference between the number of values above 0 and the number of values = 0.
Is it possible to make the difference between these 2 counts?
“Select Count(value) from “test” where value > 0”.
“Select Count(value) from “test” where value = 0.”
Have a good day.