Count string values separated by comma in single column

Grafana Time Series Panel
, , , ,
1

I’m running Grafana 7.4 and pulling in data from an api using the JSON API plugin. I’m returning a column called ‘limit’ where I’m getting values separated by commas in a single string. I’m looking to get a count of the number of values within the string.
Alternatively, if one could do a character count searching for commas that would also be effective.

image

i.e. id 30093 would return a count of 6; id 30190 would return a count of 1

I looked into using transformations, regex, value mapping, etc. but could not find a way to do this within Grafana.

2

Edit: *id 30092 would produce a count of 6.