最近搜索

没有最近搜索

Count Comma Separated Values In A Single Cell

已回答
image avatar

Anna Roth

已于 2021年1月21日 发布

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.

0

2

2 条评论

日期
    image avatar

    Stephen Belleau

    Zendesk LuminaryCommunity 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

    image avatar

    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

    请先登录再写评论。

    找不到所需的内容？

    新建帖子