0 Replies Latest reply on Oct 10, 2017 7:05 AM by Angeliki Exakoustidou

    Data joint-different number of inputs on the common column

    Angeliki Exakoustidou

      Hi All,

       

      I would like to create a graph with a dual axis, on which the data is imported from 2 different spread sheets.

       

      On the horizontal axis, I would like to project the different periods for 2017-2018.

       

      On the vertical axis I would like to see total number of incidents/accidents per project within each equivalent period, as well as total rolling hours per project within each relative period.

       

      The issue is that although the reflected periods are the same, the data they match with on the vertical axis feed in from different spread sheets and the number of inputs is not the same either.

       

      Please could you advise how this could be achieved?

       

      I have tried joining the data per periods but the result was not correct.

       

      Thank you in advance,

      Angelika