UniFi-Poller: UAP Insights - InfluxDB Guest Count displays 0

[deanjarnold]

The Guest count for the 'UAP Insights - InfluxDB' dashboard displays as 0/zero.

To fix change the query to is_guest evaluation to AND is_guest = 'true' note single quotes rather than double.

[davidnewhall]

InfluxDB is returning different results based on the quote type?

[deanjarnold]

Influx was not return any results when true was wrapped with double quotes vs single quotes.

This returned 0:
select count(distinct(hostname)) FROM "clients" WHERE ($timeFilter AND ap_name =~ /$AP$/ AND site_name =~ /$Site$/ AND is_guest = "true")

This returns the actual guest count:
select count(distinct(hostname)) FROM "clients" WHERE ($timeFilter AND ap_name =~ /$AP$/ AND site_name =~ /$Site$/ AND is_guest = 'true')

[davidnewhall]

TIl. Thanks!
https://docs.influxdata.com/influxdb/v1.8/troubleshooting/frequently-asked-questions/#when-should-i-single-quote-and-when-should-i-double-quote-in-queries