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

    Two calendars in one chart

    Виталий Чуприна

      Hi,

       

      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:

       

      DateLink:

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

      LOAD
      [ItemKey]  AS ItemKey,
      OperDateKey  as Date,
      'Operations'
      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.