prune

Use prune to perform filter operations after all other transformative directives have run on the worksheet, but before any drag-downs have started.

pebblestream:from("Customer Orders")
pebblestream:group("id")
pebblestream:sum("order amount")
pebblestream:prune("order amount", ">100")

This example will produce a worksheet from "Customer Orders" that lists customers with total order amounts over $100.

📘

The prune directive works precisely like the filter directive.