4 Replies Latest reply on Jul 5, 2017 6:23 AM by hannah.rhrbein

    Problem to create a new variable

    hannah.rhrbein

      Dear Tableau Community,

       

      I am trying to create a new variable (the city where the patient is living at the last stay in hospital).

      An example of the dataset:

       

      PatientnumberCasenumer
      Discharge date
      Dwelling place
      11105.07.2016city 1
      11210.12.2016city 2
      22103.04.2015city 3
      22215.07.2015city 3
      22301.12.2015city 4

       

      I would like to create a veriable like that, so i can use it for other:

      PatientnumberCasenumberCity (Last stay)
      111city 2
      112city 2
      221city 4
      222city 4
      223city 4

       

      I hope you have an idea and can help me.

      Thanks!