1 Reply Latest reply on Sep 21, 2018 5:19 PM by Deepak Rai

    Need help creating a column which doesn't exist in the dataset

    . Tableautester

      Normally I would create the Shared column using SQL but I am trying to use Tableau for more than just displaying data.

       

      What is the best way to create a calculated field to make the Shared column in the example data set? I was trying to do a LOD but wasn't having much luck.

       

      For each Final ID, if there is BOTH "T" and "F" in the T_OR_F column, then all the values for that Final ID are shared.

       

      Final_IDSub_IDSharedT_OR_FLatitudeLongitude
      2120noF45.1879485-68.9705844
      600yesF45.18664349-68.97356452
      6015yesF45.19094134-68.969272
      600yesF45.1881562-68.98087526
      603yesT45.1890181-68.9804041
      603yesF45.18940308-68.97952375
      606noF45.19028185-68.97847083