Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Thanks alot..That worked!!