I have defined a key to join the tables in my data model which conmprises of phone number and month. As the requirement earlier was to look at only the lastmonth.
Now I need to look at the last 6 months data and show a trend.
Should I keep the key as it is and then add a date field in each table that need to join to a calendar table?
Is there any better solution?
Thanks in advance.