In influx can you use a WHERE statement on a calculated value?
example:
select (valuea + valueb) as totalvalue
WHERE totalvalue > 1
In influx can you use a WHERE statement on a calculated value?
example:
select (valuea + valueb) as totalvalue
WHERE totalvalue > 1
It can be done using sub-queries:
SELECT totalvalue FROM (SELECT valuea + valueb as totalvalue FROM meas) WHERE totalvalue > 1
thank you that was really helpful