data not showing when connected to a date table

[df123445]

I have 2 tables:

Sent

NL 1	08/05/2024 00:00:00
NL 2	05/02/2024 00:00:00
NL 3	20/04/2024 00:00:00
NL 4	24/07/2023 00:00:00

Open

NL 1	20/05/2024 00:00:00
NL 2	05/05/2024 00:00:00
NL 3	20/06/2024 00:00:00

both are connected via a 1:* relationship to a date table. 

If I create a simple dashboard with the 2 tables and a date slider, one table is filtered as expected (the records outside the date range are not shown), while the other table doesn't show any records at all! 

looking at my example, if I select all 2024 I'll see 3 records from the sent table and NONE from the open table.

Any idea what could be the issue? both table have also other relationships, but I can't see as being an issue, after all if I remove the 

date relationship I can see all records from the open table  

Adding a couple of screenshots for clarity

TIA 

[DataNinja777 · Accepted solution]

Hi @df123445 

If the sent ID is the same as open ID, I'd recommend you to combine the two separate fact tables in one table which contains information of sent and open in same rows and have it as a disconnected table with your calendar table in order to perform flexible analysis with respect to the time dimension.  

Best regards,