Forum Discussion
Date Relationship Issue (Missing Data)
Hey all, Struggling with an issue I can't resolve. I'm trying to include a very simple column chart plotting Date by Invoice Total. The problem is that some data is being missed/ignored by th...
Hi Ryaneb85,
The cardinality for the relationship is the other way around. Calendar table (1) to Fact table (*).
Make sure your calendar table includes all the dates from the specified period.
Cheers,
Fernando
Thanks for the reply calerof
Just to clarify, are you saying the Calendar Table should be 1 and the Fact Table should be *? If so, I already have it set up this way. Dates is my Calendar table and Invoiced is my Fact table.
I've tried swapping the cardinality around just to be sure so that Calendar Table is * and Fact Table is 1, but it won't let me make this change.
I have the necessary dates included in the Calendar Table too and double checked again to make sure.
Can you show me your Calendar table?
