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: - 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