Forum Discussion

SteveMForm's avatar
SteveMForm
Icon for Helper III rankHelper 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...
SteveMForm's avatar
SteveMForm
Icon for Helper III rankHelper III
2 years ago

Hi DataNinja777 sorry for delay.

I have split the original column which had comma separated values in and get 4 new columns:



I now need to count the occurances of each value across the table- what is the best way to do this?

Thanks