Could please tell me how to join these two tables

Get Help
1

Hi everyone,I need your help with a thorny problem.

image
image1888×628 57.9 KB

image
image1888×739 78.9 KB

My requirement is to join the two tables with the Month field for analysis，but one of them is by Week and the other is by Month,I found their source data and source code.
image
image859×51 3.45 KB

image
image789×502 16.9 KB

But I don't know how to solve my problem. Could you give me some help

2

you have to join them by month in a native query, so I would first do a CTE grouping the table which is by week and then join to the one which is by month

3

@jesse1 You're seeing this issue:
https://github.com/metabase/metabase/issues/10924 - upvote by clicking :+1: on the first post