Chart from enumlist values

AppSheet AppSheet Q&A
1

I have an enumlist that gives a list of keyword values from another field. I want to make a chart based on those keywords. I know I need a count expression for each value in the enumlist but im not sure what.

I would like a count of each keyword in the enumlist named [q1 AI]

Any ideas?

2

I don’t understand. An example of the possible input and desired output would be helpful.

1 Like
3

So I am using the new AI features to pull keywords from a conversation field. The keywords are stored in an enumlist field and looks likes this as for the values

  1. managing shifting priorities, balancing multiple projects, ensuring clear communication, consistent communication, better document processes

  2. managing shifting priorities, balancing multiple projects, communication across all stakeholders, changes occur rapidly, improving communication channels

Since many of the responses are similar I would like a chart that shows a count of the individual response words.

A chart that says

managing shifting priorities - 2

balancing multiple projects - 2

ensuring clear communications - 1

communication across all stakeholders - 1

consistent communication - 1

changes occur rapidly - 1

better document process - 1

And so on.

So a chart that takes the individual values from the enumlist seperated by commas and a count of each one. Does that make sense?

1 Like
4

Thanks!

Unfortunately, AppSheet’s charting/graphing capabilities are limited, and I don’t believe you can chart individual values in an EnumList column.

An alternative would be to build a report:

  1. Create a new table called (e.g.) Keywords with a single normal column called Keyword.

  2. Create a bot that responds to adds and updates of the table that has the EnumList of keywords.

  3. The bot should add any keywords from the row that don’t already exist in the Keywords table to the Keywords table.

  4. Add a virtual column to the Keywords table called (e.g.) Conversations with an App formula like:

FILTER(
  "conversations-table",
  IN([_THISROW].[Keyword], [enumlist-column])
)

Replace conversations-table and enumlist-column appropriately.

The Keywords table should then have enough information to get you moving forward.

1 Like