How to replace NULL or missing data by joining your data in Tableau

In this silent video you’ll learn how to replace NULL or missing data with zeros or existing data by joining the original data to a master list of values in Tableau.

Read the full article here: Replace NULL or Missing Data With Zeros or Existing Data — https://kb.tableau.com/articles/howto...

- - - - - - - - - - - - - -

This option will show zeros when the data is NULL, missing or filtered out of the view.

1. Create a text file that contains a master list of all stages.
2. Create a cross-database join between the original data and the master list. Use join calculations to join the tables on 1 = 1
3. Select Analysis and then Create Calculated Field
4. In the Calculated Field dialog box that opens, Name the calculated field. In this example, the calculated field is named "New Amount with zeros", enter the formula similar to the suggestion in the article and then click OK.
NOTE: The join creates duplicate data, therefore to remove the duplicates we only want to show data where the dimension with NULL or missing values to the same value values in the Master list. The ZN() function will replace any NULL values with zero
5. In the Calculated Field dialog box that opens, Name the calculated field. In this example, the calculated field is named "New Amount with last value", enter the formula similar to the suggestion in the article and then click OK.
NOTE: IFNULL(..., PREVIOUS_VALUE(0)) will replace any NULL values with the last value of this calculation, which creates a running last value. Depending on how the view is built, it may be necessary to compute PREVIOUS_VALUE() differently.
6. Replace [Amount] on Text on the Marks card with the desired new value depending on the desired end result
7. (Optional) Customize the values in the view by right-clicking the value and formatting it as desired.


Related solutions:
Show or Hide Missing Values or Empty Rows and Columns — https://help.tableau.com/current/pro/...
Displaying Missing Values as Strings for a Measure — https://kb.tableau.com/articles/HowTo...
Join Your Data — https://help.tableau.com/current/pro/...

- - - - - - - - - - - - - -

Subscribe to the Tableau YouTube channel here: http://www.youtube.com/subscription_c...

Free Trial of Tableau: https://www.tableau.com/products/trial