4 Replies Latest reply on Mar 7, 2016 5:22 AM by Ashwini Poola

    How to use Number of records column to modify the result dynamically

    Ashwini Poola

      I have a requirement such that No data available message is displayed whenever no data is available for a report. We can't float text box for text  reports. This is because if we have only 1 line displayed in the report, then both text box and report will be visible which will be a problem.

      I am trying to use the measure Number of Records in the following way so that this calculated field can be used in title.But the output is not coming as 'not available' when data is not available.

       

      if STR([Number of Records])='None' then 'not available'

      else 'data'

      end

       

      Can some one help me how tableau understands this column

       

      Thanks,

      Ashwini