Issue creating multi-join activity chart by Date in embedded Metabase (Custom Columns & Question-as-source blocked)

Get Help
1

Hello everyone,

I'm using an embedded version of Metabase integrated into our CRM, and I'm trying to build a consultant productivity dashboard.

My starting point is a Users table, and I need to combine activity data from multiple tables:

  • Users → Calls (Users.Id = Calls.User_Id)

  • Users → Tasks (Users.Id = Tasks.User_Id)

  • Users → WhatsApp Templates (Users.Id = WhatsAppTemplates.User_Id)

I'm building this using the GUI Query Builder only.

The problem is that each of these tables has a one-to-many relationship with Users. When I join them all together, the result becomes a Cartesian product, causing all activity counts to be inflated.

To make things more challenging, I also need to filter or display the counts by day (for example, "activities completed today"). Each activity table has its own date field:

  • Calls → Created_At

  • Tasks → Completed_At

  • WhatsApp Templates → Created_At

Unfortunately, my embedded environment has several limitations:

  1. I can't use SQL

  2. I can't use Saved Questions or Models as the source for another question

Given these constraints, what would be the recommended approach to count each activity independently per user and per day without the joins multiplying the rows?

Is there any technique within the Summarize or Filter steps of the GUI Query Builder that can avoid this issue, or is this simply not possible with the visual builder alone?

Thanks in advance for any suggestions!