Count Comma Separated Values In A Single Cell

2 コメント

  • Stephen Belleau

    Hey Anna Roth 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

    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

サインインしてコメントを残してください。

Powered by Zendesk