1 Reply Latest reply on Oct 20, 2018 10:51 PM by Tushar More

    Show Top and Bottom N Together Excluding Missing Values

    Carly McCann

      Hi all,

       

      I am working with a large table and so I created a view showing just the top and bottom values using sets as shown here: How to display Top N and Bottom N in the same view Tableau - 2 Ways to do it - YouTube 

       

      However, I have missing values and these show up in the bottom set  How do I ignore missing values so that the smallest non-missing value shows up in the bottom set?

      Attached a is a simple fake example to illustrate my problem.

       

      Thanks,

      Carly