Simple table with a join (Mongo)

1

I was thinking this would be trivial in Metabase but now am not sure it’s even possible.

I want a simple table with 1 row for each user and then columns such as number of payments and payment volume. It would be nice if I could “join” my payments colleciton to my users collection so I could display the user name instead of Mongo ID.

For example:

USER        #          VOL
-----------------------------
User A      10         10,000
User B      12          9,888

And then be able to apply some filters like a date range.

Possible?

2

“Payments > Count of rows by User ID” gets me:

User ID      count
1234           10
5678           12

Is there a way to add “Sum of Amount by User ID”?

Is there a way to look in the Users collection by ID to get the User Name?