Count words (tags) from a column

[Anonymous]

Hello!

I have several columns with tags that I've prepared based on text comments by survey respondents. 

Now I would like to show both the number of comments collected (this is easy) and the number of tags delivered from that comments (one comment can generate 1, 2, 3... tags). I have a column like this that works great for a word cloud extension:

TagsQ1

greenapples

greenapples orangepeaches

orangepeaches yellowbananas

greenapples orangepeaches

etc

What is a possible solution to count tags in each row? I have empty rows also in this column, because not all respondents were leaving comments.

Thank you!

[v-yuta-msft]

@Anonymous ,

In query editor, click split columns and then select the column containing text then click uppivot, finally click group by with aggregation count based on the attribute column.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Dear Jimmy from @v-yuta-msft,

Thanks for you reply! I've tried and It worked, but I'm still struglling how to visualize the count of tags. Basically I have 3 columns with tags in one table relevant to three different questions from the survey. Previously I've appended the table with tags to a primary database containing all answers and demographics data using the unique ID of each respondent.

So what is the most optimal way to link the count data of tags with the primary database, because I need all slicers to work properly (like they work with the count of comments)? To be super clear, when I select city A and Department C an exact number of collected comments is shown for this selection, so how do I do the same for tags?

Thanks.

[v-yuta-msft]

@Anonymous ,

Could you share some sample data and clarify more details about your requirement?

Regards,

Jimmy Tao