Forum Discussion
Count words (tags) from a column
Community SupportAnonymous ,
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.
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