5 Replies Latest reply on Apr 4, 2017 7:06 PM by Kashish Chauhan

    help formula for: by [variable], if [variable1] = 1 then [variable3]

    Leslie Raillon

      Hi,

       

      I have a tricky formula I would like to create.

       

      Here is what I need looking at this database:

               

      User_IDNth_Device_IdNth_device_typeNth_device_familyNth_Device_retailer_idNth_Device_countryNth_Device_date_setupDelayRANK_with_accessoriesRANK_without_accessories
      1A1BNACameraMainBobFR25/02/201548322
      1A2BNACameraMainBobFR26/05/201557333
      1A3BNAPlugMainBobFR04/09/201567444
      1A4BNAPlugMainBobFR30/10/2013011
      2A1BNACameraMainMarthaFR26/01/2016011
      2A2BNOCAccesoryMarthaIT29/11/2016308 2

       

      I would like to add a new column in Tableau, "1rst device type": by same user_id, if "rank_with_accesories" = 1 then "Nth_device_type"

       

      Any idea?

       

      Thanks a lot,

       

      Regards,

       

      Leslie