Month in the data model

[qliktech_uk]

Hi,

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.

[zhadrakas]

i would definitely add the date field and add a master calender.

Master Calendar Generation Script

i think you have to Keep the key as it is.