Hey,
We are using a enumlist for a question called “product interest” for a expo client
Product interest:
Choc bar
Mars bar
Picnic bar
Etc
We’ve built a bar graph to give them an idea of top products, however its pulling all unique answers through, not the total number/time Choc bar was selected or Mars bar was selected.
Is there a way to build a bar graph by counting the number of times each product was selected? Not the bunch of products selected in one lead?
If need more info reach out
Cheers
Hi,
You can do this with some outside program such as Python to separate those items and then write back the count. However, I am assuming that you want something that will work purely in AppSheet. To get it to work in AppSheet I would recommend dropping the enumlist and creating a referenced table that the user can add as many items that they want.
See:
https://www.appsheet.com/samples/A-basic-demo-of-table-references?appGuidString=6ffad040-b04a-4325-aa73-ace5df8ba1b5
Your best bet is to use sheet formulas in a separate sheet to process the data and shape it like you need to display in the chart.