How to make a chart view for below column data with the sum of all quantities in each column.
The chart should be displayed in this way. I can create with using an additional sheet tab, but is there any way to create this with AppSheet ?
Only in the chart preview, because you manually choose the "major" dimension. Even then, you'd have to have a column that holds the same value for every record, and use that as the "major". Another options is to the sum the values in another table and build a chart on that.
"sum the values in another table"
Can we use AppSheet formula instead of using spreadsheet formula?
Sure
Can you help with that?
Probably
User | Count |
---|---|
32 | |
11 | |
3 | |
3 | |
2 |