Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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.
How do I check? They both show as dates in the association window.
Try something like:
Date(Trim(we_date)))