ah sorry I can’t work out how to edit my previous post…
It now gives me the error “PlanExecutor error during aggregation :: caused by :: Exceeded memory limit for $group, but didn’t allow external sort. Pass allowDiskUse:true to opt in.”
I tried filtering the view as you suggested,
But it gives me the same error.
I’m using Compass version 1.20.5 and the deployment is a MongoDB 5.0.2 Community on a kubernetes cluster
Thanks again,
Emily