1 2 Previous Next 15 Replies Latest reply on Nov 17, 2016 11:58 PM by Patrick Schmitt

    Problem with Dates

    Patrick Schmitt

      Hey all,

       

      I´m tryiing to create a dual-axis linechart with following details:

       

      On Y-Axis: Error Quote and Output Quantity

      On X-Axis: Year and Month

       

      Problem is, that we have two different tables with different date rows, connected via data blending

      The two columns with the "Created on" 26th and 27th aren´t shown in the linechart so that we just would have an "Error Quote" of 25% instead 43,75%.

       

      Table "Production Orders" (M-SQL):

      Item No.Finish DateOutput
      .........
      Y1000.000.0028/10/165
      Y1000.000.0030/10/1610
      Y1000.000.0031/10/161

       

      Table "Error Report" (M-SQL):

      Item No.Created OnError QuantityError Quote
      Y1000.000.0026/10/162-
      Y1000.000.0027/10/161-
      Y1000.000.0030/10/16425%

       

      Is there a possibility to deal with that issue?

       

      Thanks a lot community

        1 2 Previous Next