Anna Roth

Thank you so much!

I fiddled around with that formula, It was exactly what I needed.

 

However since for some reason it doesn't include the last number, I added a +1 to offset it, after that my numbers came out accurate:)

 

LENGTH([your ticket attribute]) - 
LENGTH(REPLACE([your ticket attribute],",",""))+1

Hello!

 

I am new to Explore and I have tried looking for a solution in terms of COUNT value seperated by comma in a single cell

 

I tried adding formulas I usually use in excel and I have had no luck so far.

Example:

 

What I am trying to achieve is this:

 

I hope someone can help me figure this out or point me in a possible direction.