Create a column chart with the most common words in a column

I have a column in my entity called comments, and my idea is create a column chart to display the most commons words. Any idea how to do it?

I didn't use real data or check the performance of this flow but this logic works I think with some tuning here and there.


Here's the structure used for the List of words:


If you have any question let me know.

Hi Gonçalo,

I used a similar example to what you need.

  • On Preparation create an aggregate grouped by Comments column and with a Count column:

  • On UI, create a ColumnChart and assign to it the Agreggate.List data with the Label being the Comment column and the Value the Count.


This will check which comments are exactly the same and will count them. But thanks very much for the tip! :)

Sorry, I misread your needs.

Let me think of a solution.

I didn't use real data or check the performance of this flow but this logic works I think with some tuning here and there.


Here's the structure used for the List of words:


If you have any question let me know.

Thank you José! I will try it and soon i let you know!

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.