Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

data not showing when connected to a date table

I have 2 tables:

 

Sent

NL 108/05/2024 00:00:00
NL 205/02/2024 00:00:00
NL 320/04/2024 00:00:00
NL 424/07/2023 00:00:00

 

Open

NL 120/05/2024 00:00:00
NL 205/05/2024 00:00:00
NL 320/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 

 

 

Need Help
  • DataNinja777's avatar
    DataNinja777
    2 years ago

    Hi Anonymous 

    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,

     

1 Reply

  • DataNinja777's avatar
    DataNinja777
    Icon for Super User rankSuper User
    2 years ago

    Hi Anonymous 

    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,