How to calculate matched groups in value mapping


I have a field like “IP1,IP2,IP3,IP4,…”, I need to replace the field with the number of IPs. For example, if the field is “,,”, I need to replace this field with “3 IPs”. If the field is “,,,”, replace it with “4 IPs”. How to make it?


What is your datasource


So is it only one field or mutiple fields?

Also are you using influxql or flux query language

only one field. I’m using influxql