Calculate the difference between 2 Count

InfluxDB 2 Dashboards
,
1

Hello,

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.”

Best regards,
Have a good day.

2

“select spread(count) from (select count(value) from test where value > 0),
(select count(value) from test where value = 0)”

Antony.

1 Like