Not only is Tableau a great data analysis tool, it’s also really useful for data discovery. One of the helpful ways you can use Tableau is to uncover inconsistencies and holes in your data structure. I do this by finding out what data unexpectedly has null values.

Whenever I see a null indicator like in the below image, I start digging into the data:

5-1.png

 

Investigating the Nulls

1.       Start by creating a new worksheet and pulling a measure onto Rows.

2.       After placing the measure, use the dropdown to change it to be both a Dimension and Discrete.

5-2.png

If there is null data, “Null” will automatically sort to the top of the headers after doing this.

3. Add the Number of Records measure to Text on the Marks card.

4. Right-click on the records listed after Null and investigate.

5-3.png

Need more help?  Please contact us at freesupport@onenumber.biz.

Why Won’t My Excel File Refresh?

Computing Header Totals in Tableau

0