4 Replies Latest reply on Nov 5, 2018 12:37 PM by Jennifer VonHagel

    Delete Null values from the data

    Tableau G

      Hi,

       

      I want to know  popular trips between two stations and created a table using From station and to station and count of total Trips. I have created a calculated field to give max of count and wanted to delete all the null values which doesnot have the values. I tried with set, created parameter field but it is not working. Even sorting is not giving me correct values . Can you let me know what to do to get correct sort. My results should be as follows

       

         

      From stationTo stationCount Distinct Trip id
      Pier 69 / Alaskan Way & Clay StPier 69 / Alaskan Way & Clay St4209
      Pier 69 / Alaskan Way & Clay StSeattle Aquarium / Alaskan Way S & Elliott Bay Trail2291
      Seattle Aquarium / Alaskan Way S & Elliott Bay TrailPier 69 / Alaskan Way & Clay St1605
      3rd Ave & Broad St2nd Ave & Pine St1101
      2nd Ave & Pine St3rd Ave & Broad St962
      Lake Union Park / Valley St & Boren Ave NLake Union Park / Valley St & Boren Ave N960
      E Pine St & 16th AvePine St & 9th Ave934
      Burke-Gilman Trail / NE Blakeley St & 24th Ave NEBurke-Gilman Trail / NE Blakeley St & 24th Ave NE880
      Dexter Ave N & Aloha StRepublican St & Westlake Ave N759
      Westlake Ave & 6th AveDexter Ave N & Aloha St749
      2nd Ave & Vine St2nd Ave & Pine St743
      King Street Station Plaza / 2nd Ave Extension S & S Jackson StPier 69 / Alaskan Way & Clay St737
      1st Ave & Marion StPier 69 / Alaskan Way & Clay St672