Forum Discussion

SteveMForm's avatar
SteveMForm
Helper III
2 years ago

Counting comma separated values in a column

Hi Folks   I'm using a doughnut visual to try and show a count of occurances of a each unique value in a column:     As per above, they are also comma separated, and a value can only...
Ankur04's avatar
Ankur04
Resolver II
2 years ago

Hi,

 

As I can see there are many rows where you have comma separated values. you can create new columns for each value, then try to pivot it.

another point as highlighted, each row can have only one value. so if you make a pivot each row may have more than one value. In that case you can create a logical grouping and take count of that column.

 

hope this may help to get some idea. please free to provide further info more better understanding.

 

Happy to help!

  • SteveMForm's avatar
    SteveMForm
    Helper III
    2 years ago

    Hi Ankur04 

    As I mentioned, I don't really wnat to keep having to pivot the table to extract values, so was looking for another wasy to get the values out.

     

    It is not that each row can only have one value, otherwise I wouldn't have the challenge to count the distinct values and the visual would work out the box. When I mentioned unique values, it is that each unique value can only appear once in each row. It might be that several unique values apply for a row in that specific column, and thats part of the challenge.

     

    Can you tell me more about a logical grouping

     

    Thanks