0 Replies Latest reply: Feb 12, 2016 6:03 AM by J Schloesser RSS

    Use inline table for goals?

    J Schloesser

      Hi,

       

      At this moment I have the following tables (which are pulled from CRM):

      cdi_Postedforms

      cdi_Visits

      Master_Calendar (script which enables the use of day, week, month and year inside my project).

       

      From the Visits I created an graph which displays the visits on our domains (current vs previous year (filtered on month)):

      Knipsel.PNG

      Now I want to add an goal for every month, domainname and source. So basically an table which contains: Month, Source, Goal and Domain which is connected to the Table Visits (which also contains domain and Source) and the table Master Calendar to connect the month.

      Knipsel1.PNG

      Whenever I try to add more then one key (Source -> Source, Domain -> Domain or Month -> Month) it creates an sync table, how can I avoid this?