A way better than rollup and transform

Regarding your transform configuration:

Per default documents with null values are ignored, however you can change this behavior if you set missing_bucket to true, see this example.