I found a tutorial describing how to setup alerting with influxdb on chronograf. It displays the time series section and the section to enter a query to select the fields needed. The version we are running does not give you that option to add a query, only to select the measurement and field. I want to be able to monitor the values of a field that is filtered based on another field, something like this:
SELECT attr_value FROM "streamDB"."default"."jmx_metrics" WHERE "beanName" = 'controller:name=OfflinePartitionsCount,type=KafkaController'
The alert will then monitor that bean value (attr_value). Is there a way to do this or get the query box?