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