4 Replies Latest reply on Mar 3, 2016 3:40 AM by mafalda.santos

    Exclude null values from an index with a fix size (5)

    mafalda.santos

      Hello all

       

      I need to create a top 5 for a measure.

       

      The problems is that there is some nulls where we don't have data which Tableau is automatically ranking instead of missing it out.

       

      I just want to show the records that starts on citie C. Immediatly after null and + 5 (C,D,E,F,G)

       

       

      CitiesMeasureRecord
      ASales
      BSales
      CSales13
      DSales14
      ESales15
      FSales16
      GSales16.5
      HSales18

       

       

      I found one possible solution for the problem but it didn´t work --> if not isnull([measure) then index() end

       

       

       

      Any suggestion gratefully appreciated!