I have a field in Influxdb called FIXConnected and the values could be True or False.
The query below brings me these values but i need to create an alert and i need to make these true or false as 1 and 0.
SELECT distinct(“FIXConnected”) FROM “koala_application” WHERE (“args1” = ‘fixserver-xxx-yyyyy’) AND $timeFilter GROUP BY time(1m) fill(null)
Is there any other function instead of distinct or a composition of other functions that could be used in this case ?
I am new to influxdb and appreciate your help.