LinkedIn
Twitter
Hello,
I am looking for AppSheet ninja โ๏ธ that knows how to solve this.
I have a table with 1 column with Player, 1 column with Character, and 3 columns with Items (of the character).
I want to display a chart that fetch all the items selected in the 3 columns in order to visualize the frequency of each item via `aggregate piechart`.
Constraint:
- The source has security filter so the gamer1 will only see their data and gamer2 will only see their data.
In google sheets will be looking like this, but in Appsheet I do not know how to perform it.
Thanks in advance.
Solved
1 ACCEPTED SOLUTION
Thanks again for all your inputs, much appreciated.
At the end I could replicate my need by having another table in GoogleSheets, with my expected table using formulas.
Flattening all my data and also keeping the Player name for the Data Security Filters.
FORMULA
ArrayFormula( SPLIT( FLATTEN('GCloud Community'!$A$4:$A$9&","&'GCloud Community'!$C$4:$E$9), ","))
RESULT
This allowed me to create the charts with the user item entries (for the 3 cols).
