Canonical date

[#1]

Hi all,

hic‌

I have created a canonical date using below script.

invitation_id2Date:

     Mapping Load invitation_id, Date Resident INVITATION ;

invitation_id2date_accessed:

     Mapping Load invitation_id, date_accessed Resident SIGNUPACTIVITYLOG ;

DateBridge:

     Load invitation_id, Applymap('invitation_id2Date',invitation_id,Null()) as CanonicalDate, 'invitation' as DateType

          Resident INVITATION;       

     Load invitation_id, Applymap('invitation_id2date_accessed',invitation_id,Null()) as CanonicalDate, 'accessed' as DateType

          Resident SIGNUPACTIVITYLOG ;    

     Load invitation_id, date_completed as CanonicalDate, 'completion' as DateType

          Resident COURSECOMPLETION;

I have used canonical date in my sheet, when i filtered the canonical date it's not applying the filter, some extra data is adding.

I have attached the image where you can see i have filtered for date 20/09/2015 but why 23rd and 21st is adding.

can any one explain why this is happening?

Thanks,

Pramod

[hic · Accepted solution]

This is how a canonical date works. So you have probably done it correctly.

You have three dates: Invitation date, Accessed date and Completion date. If you select 20/09/2015 in your canonical date, then you will select all invitations where any of the three dates has this value. But (for a specific invitation) the other two dates may still have other values...

HIC