MongoDB join questions

I have a collection called “Orders” which is consist of orders from all shops. each document have Order amount and Shop ID

in order to pull the data of that Shop ID I need to look up in “Shops” collection.

how can I create a question that shows list of top shops sorted by total order amounts?

Hi @hadifarnoud
Metabase currently doesn’t support joins on MongoDB through the UI:
https://github.com/metabase/metabase/issues/9095 - upvote by clicking :+1: on the first post
You would need to do it with a Native question - you’re likely going to find more examples on how to write queries in a forum dedicated to MongoDB or stackoverflow.com