How to add a weekly count of 2 distinct values in 1 table

Get Help
1

Screenshot 2024-06-11 at 10.25.41 PM
Screenshot 2024-06-11 at 10.25.41 PM778×1130 63.7 KB

Screenshot 2024-06-11 at 10.26.27 PM
Screenshot 2024-06-11 at 10.26.27 PM980×1130 67.3 KB

I have an application where users create an account & then connect their email. As you can see from screenshots, I have a table showing the weekly count of how many accounts were created & how many emails were connected in 2 separate tables.

I want to know how I can combine the tables so I can see the weekly count of accounts created & emails connected in 1 table.

Goal: I want to be able to calculate the % of accounts that connect their email (by week).

Is this possible to do in the Metabase question tool? Or would this require some SQL?

2

You should be able to do this form the Question tool. When you "join" data you can choose another Question to join to. In this case you could likely join on date then use custom expressions to do you rate calculation.