Facts table not getting linked with Master Calendar

[Anonymous]

I need to plot the number of tickets resolved per month

I have added the master calendar and linked to the resolve dates but the dates are not gettting linked to show the tickets.

Can anybody please help? is this anything to do with timestamp issue?.

[sunny_talwar · Accepted solution]

Try the attached. New Script:

TR_Dump:

LOAD [Date Raised],

    [TR #],

    Date(Floor([Resolved Date])) as [Resolved Date]

FROM

[Test Data.xlsx]

(ooxml, embedded labels, table is [TR Dump today]);

[its_anandrjs]

In your excel file date is not on proper order please check after correction you get right data.

Regards,

Anand

[Anonymous]

Thanks..This has worked..Can you please help me understand what floor has done in this expression? i tried using only date function and it didn't work

[Anonymous]

Also will you be able to help me with another query?

I need to create another master calendar to link the Date Raised field from the facts table. If i use the same master calendar script will it not disturb the data as Month is common in both the master calendar scripts?

[sunny_talwar]

Floor removes the time component from a date and time field. I think the connection between master calendar and your fact table broke because of time in the [Resolved Date] field. It would be good to read about dates here:

Get the Dates Right

Why don’t my dates work?

[sunny_talwar]

Read here:

Canonical Date

Handling Multiple Calendars.qvw

Linking to two or more dates