I have a column that collects a first reason for consultation. And I have another column that collects or second reason for consultation. And I have a third column that collects the third reason for consultation. But I would like to be able to know all the reasons for consultation, to have a chart of all the reasons for consultation, whether they are the first, second or third. How can I do this accumulation of two or more data (not a sum)?
Hello. This is a parent-child or item-detail pattern. We have a handy note and example app here: https://help.appsheet.com/en/articles/1128191-the-item-detail-data-pattern
And in general, a good design series here: https://help.appsheet.com/en/collections/378176-app-design
Hopefully that first article is exactly what you are looking for. In short: instead of three columns on a table, you want two tables which are related to each other.
User | Count |
---|---|
18 | |
9 | |
8 | |
5 | |
5 |