Cannot filter dashboard questions by foreign ID (mongo)


#1

We run a B2B SaaS tool. We’re building a customer engagement dashboard. You plug in a customer’s companyID, and Metabase generates a series of charts showing various levels of engagement.

Let’s say I have three tables: Post, Comment, Vote. Each has a companyID field on it.

I can’t get Metabase to take the companyID as an input, and plug it into a question for each table.

Here’s what I’ve tried:

  1. Using Company.ID. I can select this field, but then when I load the charts, I get the following error message: “Foreign-keys is not supported by this driver” because we’re using MongoDB.
  2. Vote.companyID, Post.companyID, Comment.companyID fields do not show up in the filtering, presumably because they are foreign entities, not IDs.

How can I achieve this? Do I have to remove the foreign key relationship between my tables, because I’m using mongo? That seems a bit silly.