1 Reply Latest reply on Mar 27, 2018 9:09 PM by Deepak Rai

    Get the latest location for each user

    sara.siu

      hi community, i am a newbie to Tableau , can anyone gives me a hint on this probleam

      if i have the following data source if there is any way i can add a calculated field to have the latest location(based on date) for each user_id?

      locationuseriddate
      PH1112016-04-07
      PH1112016-04-10
      PH1112016-04-19
      HK1112018-03-13
      HK1112018-03-10
      HK1112018-03-20
      SG2222017-12-01
      SG2222017-12-22
      SG2222018-01-02
      HK2222018-02-03

       

      thenthe result shall become below

      locationmaxlocationuseriddate
      PHHK1112016-04-07
      PHHK1112016-04-10
      PHHK1112016-04-19
      HKHK1112018-03-13
      HKHK1112018-03-10
      HKHK1112018-03-20
      SGHK2222017-12-01
      SGHK2222017-12-22
      SGHK2222018-01-02
      HKHK2222018-02-03