Link not getting created between master calendar and main table

[mugdhaojha]

Hi,

I am trying to develop a dashboard with ticket details and for that I have created a master calendar.

But somehow the master calendar is not getting linked to each incident number in the main table.I have checked the data and there are no records without the Reported date(field on which I have created the master calendar).

I have attached some screenshots of the issue.

[Gysbert_Wassenaar · Accepted solution]

Make sure that the dates in your fact table and master calendar are dates and not timestamps. You can use the floor function to cut of the time part from timestamps if necessary: date(floor(TicketOpeningDate),'YYYY-MM-DD') as TicketOpeningDate

[mugdhaojha]

Thanks alot..That worked!!