help with linking master calendar to multiple dates across multiple tables
i have a variety of different dates across multiple tables. i want to link them all to a master calendar but i am struggling to do it. i have tried creating a calendar per table then linking those to a master calendar but i cant seem to get it working.
Re: help with linking master calendar to multiple dates across multiple tables
I created an example qvw using technical Canonical Date. First the quality of your data is poor and I use Campaign_ID to Primary Key, and don't Load rows if Campaign_ID doesn't exists. I used start_date to Principal Date and only is an idea.
The filters on list box always show the first value column of Table Box.
Repeat, it's only an idea of structure but the data is not correct.