Spilling FILTER

Summary

This video looks at how to spill multiple FILTER functions as an array.

Tab in example file: Spilling FILTER

This video does not go deep into the techniques, but is to demonstrate the approach for creating dynamic groups.

The Group Filter Aggregate method always returns a single value. Therefore, to spill multiple values we must use LAMBDA with a helper function.