3 Replies Latest reply: Jun 19, 2017 2:00 PM by David Forest

# Association two fields, one calculated

Hi, I'm trying to create an association between two tables.  Table A has state and date, the Table B has state and week ending date.  I created a calculated field for week ending date in Table A.  When I try to create graphs on date, it shows one of the data sets by time, and lumps the rest into a bar, as if the association isn't working.  Image below.

I created test tables joining on state and date, no calculated fields, and it worked correctly.  I also created test tables joining on dates, one week ending, the other calculated to week ending, and that worked fine.  Having trouble with both at the same time.

 we_date valueb state 1/8/2017 100 AZ 1/15/2017 110 AZ 1/22/2017 90 AZ 1/8/2017 200 TX 1/15/2017 190 TX 1/22/2017 210 TX

 date valuea state 1/2/2017 12 AZ 1/3/2017 12 AZ 1/4/2017 12 AZ 1/5/2017 12 AZ 1/6/2017 12 AZ 1/7/2017 12 AZ 1/8/2017 12 AZ 1/9/2017 12 AZ 1/10/2017 12 AZ 1/11/2017 12 AZ 1/12/2017 12 AZ 1/13/2017 12 AZ 1/14/2017 12 AZ 1/15/2017 12 AZ 1/16/2017 12 AZ 1/17/2017 12 AZ 1/18/2017 12 AZ 1/19/2017 12 AZ 1/20/2017 12 AZ 1/21/2017 12 AZ 1/22/2017 12 AZ 1/2/2017 24 TX 1/3/2017 24 TX 1/4/2017 24 TX 1/5/2017 24 TX 1/6/2017 24 TX 1/7/2017 24 TX 1/8/2017 24 TX 1/9/2017 24 TX 1/10/2017 24 TX 1/11/2017 24 TX 1/12/2017 24 TX 1/13/2017 24 TX 1/14/2017 24 TX 1/15/2017 24 TX 1/16/2017 24 TX 1/17/2017 24 TX 1/18/2017 24 TX 1/19/2017 24 TX 1/20/2017 24 TX 1/21/2017 24 TX 1/22/2017 24 TX

• ###### Re: Association two fields, one calculated

Hi,

Please note that the date in the chart of your picture is in a numerical format. Perhapsyou have is one of the two dates presented in the form of a number, the other in the form of a date. Then there will be no association between the tables.

• ###### Re: Association two fields, one calculated

How do I check?  They both show as dates in the association window.

• ###### Re: Association two fields, one calculated

Try something like:

Date(Trim(we_date)))