Dynamic Queries for MongoDB Atlas Charts

I answered something similar recently that may be help, you can add a custom pipeline to the report query:

You should be able to do something similar in your query that the report uses.