As the title says, I haven’t been able to find anything like the possibility of creating slices with a Group By feature. I think this would enhance considerably the possibility to create charts without the need to do hacks or workarounds.
Consider a Sales table and the need to chart sales grouped by day / week / month.
Currently, to my understanding, this is only possible through hacks like:
- creating a query in the Sheet itself and importing it into AppSheet like a new Table;
- creating an empty table in AppSheet and creating cumbersome workflows to add records to this table when new sales are created. And make a chart on this table
Or am I missing something?