My program (build on spring boot) has lots of functions, we collect the function called count to the influxdb.
It has hundreds of field keys in a measurement, like: functionA.count, functionB.count, functionC.count, functionD.count…and so on. I would like to show the field witch value is not zero with graph or table panel in grafana. How can I drop the field witch value is 0. I had tried to search document of influxdb and grafana, but can’t get the way.
select last(/count/) from test where $timeFilter group by time(1m) , this influx statement return hundreds of field keys, some value is greater than zero, most is zero, How can I filter the fields witch value is not zero in influx, or drop fields witch value is zero in grafana?