Count Comma Separated Values In A Single Cell

Answered

Anna Roth

January 21, 2021 11:11

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.

2 Comments

Stephen Belleau
- January 21, 2021 18:48
Community Moderator
Hey @... good question. I think I was able to replace the excel function in explore. I don't have any comma separated values to test with but it seems to work when I tried to count other things.

Create calculated metric
```
LENGTH([your ticket attribute]) - 
LENGTH(REPLACE([your ticket attribute],",",""))
```
That was based on the excel formula of
```
=LEN(A2)-LEN(SUBSTITUTE(A2,",",""))
```
0
Anna Roth
- January 22, 2021 08:31
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
```
0

Please sign in to leave a comment.

Powered by Zendesk