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

    Two calendars in one chart

    Vitalii Chupryna

      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.