Incremental Slicing

In some advanced cases of creating Slices, it would be very handy, and more performant, to base one Slice on another Slice, instead of all of them on the base Table. This way one can avoid having to repeat certain conditional expressions.

Consider this hypothetical example:
The data:

Slice #1 “USA Clients”
Row Filter Condition = [country] = "USA"

Slice #2 “USA Consulting Clients”
Row Filter Condition = [service_required] = "Consulting"

It would be handy to have Slice #2 be based off of Slice #1, which already filters down to USA. Otherwise I have to add Slice #1’s Row Filter Condition into Slice #2’s Row Filter Condition, along with an AND(). Not a huge deal in this simple example, but imagine if that first condition was an expensive SELECT(), and it would be getting needlessly repeated.

I realize now that it is not necessary to exactly repeat the first condition in the second slice, one could just add:
IN( [_THISROW] , Slice1[key] )

So the performance boost aspect of this request is maybe not great, but I still think it’s a cleaner and handier way to setup incremental slices.


It would be cleaner, and more intuitive and #NoCode-ish for users.

  • They’re likely thinking, “I need to slice the slice” anyways.

I seem to remember this was possible back when I started with AppSheet.


Coming back to this, and realized I had freed up some votes. So now this request has its first vote!

1 Like