Hi, 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-xx…

What about filtering the field value itself? It’s not as performing as filtering tags (as fields are not indexed) but for small amout of data it works fine. SELECT COUNT("FIXConnected") WHERE ("args1" = 'fixserver-xxx-yyyyy' AND "FIXConnected" = 'False') AND $timeFilter GROUP BY time(1m) FILL(nul…

Influx query to transform true or false to 1 or 0 (To use on Grafana Graphic Alert)

InfluxDB 2

tim.hall April 30, 2021, 4:50pm 2

I would suggest moving to 2.x and using Flux for this. This type casting is part of the Flux language.

1 Like

Topic		Replies	Views
Convert "true" & "false" values to "1" and "0" in influxdb	0	534	March 12, 2020
Flux query problem Fluxlang influxdb , grafana , flux	2	325	April 19, 2023
Pivot / Inconsistency with boolean values / FLUX Telegraf influxdb , time-series , query , flux	1	693	December 4, 2020
Struggling with query from 1.8 to v2 in Grafana InfluxDB 2 grafana	3	444	May 1, 2021
InfluxQL count with subquery in Flux InfluxDB 2 flux	3	1410	December 14, 2020

Influx query to transform true or false to 1 or 0 (To use on Grafana Graphic Alert)

Related topics