5 Replies Latest reply on Jun 6, 2014 12:16 PM by Don Barnetson

    Add missing data with a secondary data source = to 0 to replace NULL's. Can this be done?

    Don Barnetson

      Hi,

       

      I am working with a data source from SQL that has over 80M+ records, of which, approximately 15% of the sub-category items are missing monthly data (i.e.; Jan = $12, Feb = $23, Apr = $7 - the data is not showing a record for March). Is there a way to mock this missing data through a secondary data source or even a formula within Tableau equaling a value of 0?

       

      0's can be added to replace the NULL's in the main data base, but will add too many records.

       

      If anyone can help me with this it would be greatly appreciated.

       

      Thanks,

      Don