6 Replies Latest reply: Apr 6, 2017 12:47 PM by Anil Samineni RSS

    Two calendars in one chart

    Vitalii Chupryna



      I'm trying to combine two tables with different calendars into one chart.

      Tables are linked by item code and I created link table with following fields:



      [ItemKey]  AS ItemKey,
      TransDateKey as Date
      AS DateType
      Resident Trans;

      [ItemKey]  AS ItemKey,
      OperDateKey  as Date,
      AS DateType
      Resident Operations;


      And the problem that I can't correctly load data.

      When I load Item and TransDateKey from Trans table I have 120 items for 2017-04-06

      But when I load data with DataLink table I chose DateType Trans and get another results, for some reason I get 2481 item.


      At the moment I cant understand what is wrong.