Forum Discussion

9 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    6 years ago

    Hi,

    On the data that you have shared, show the exact expected result in a simple Table format.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      This the expected result

       

      YEARDEPARTAMENT changedpromotedjoined the companyhave left
      20130000
      20142210
      20151201
      20162311

       

      Example:

       

      * Department Changed:

      ID 1 ID 1 was changed from department A to department B in 2014.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        6 years ago

        Hi,

        Your and my answers for Department changed do not match for 2015 and 2016.  For 2015 and 2016, the answer should be 3 (see screenshot below) and revise the answers that you have shared.