I have tried using lookup option to join 2 different collections under SAME database & that works. But is it possible to join fields from 2 different databases.collection in mongo db aggregation ? If not what’s the way to connect them in Grafana ?

I’m trying to get the results of a MongoDB query to work as the source of a data visualization in Grafana. The query results are not in a format that Grafana will accept for a visualization. I’ve tried modifying the query and using Grafana transformations, but neither have succeeded.