Dealing with NULLs (or missing values) in Tableau | Tableau Training | sqlbelle

What do you do when you have missing values in your dataset? You cannot simply ignore it. You have to handle NULLs or missing values, otherwise you could get incorrect results.

In this video I will walk you through what happens with NULL values, and how you can handle them in Tableau. Examples include using IFNULL, ISNULL, IIF, IF/ELSE and ZN functions.

[xiao_wang]

Awesome content. Could you do a session of scaffolding method to deal with null dates?

[equiwave]

Thanks for this short but very useful video!!!
The ZN function is something that will be very useful in any data analysis.

[vickybisht]

Your way of explaining everything is awesome. I really like they way you teach everything

[ravinduabeygunasekara]

Great descriptive video. Thanks a lot for doing this

[jimmypaterson]

Hi Belle, can we replace nulls with another string say NA when comparing integer/float datatype fields in calculation, i don't want 0 as it emphasizes presence of data, i tried work around where i converted my measure to string data type which enabled me to have NA but then i lost the number formatting feature(thousand separators) tried custom calculation for formatting but facing challenges for when the number is negative. Am i missing something?

[thanugamage]

Please do a video on how to handle data source changes such as field name changes. You are awesome.

[Aayisha-dt]

hi, The video is very helpful. But I am Not able to change BLANK fields (having no values) to 0 (zero). I think these conditions works only for NULL values. Please guide.

[Azxios]

Thank you for sharing, the ZN Function is the one I'm looking for

[Data_Mom]

easy explanation with good examples, thanks for sharing

[srem]

Hi Donabel, how can you create a continuous line graph (dates in columns, and measure in rows) if some days have a NULL value? Thanks

[pankajmathur]

Thank you once again Belle. It is a request belle, kindly make some videos on projects also. :)

[tracieh]

If I'm trying to calculate the difference (let's say sales) from multiple years individually to a baseline year, and there are sales for an order id in the baseline year but not necessarily in ALL of the other years, I'm finding I can't get IFNULL, ISNULL and ZN to work for me when the data doesn't exist. Table calcs work for year over year but trying to compare each of them to a baseline year NOT through a table calc is struggle... any advice?

[chaqmedia]

It is show as "None" when i applied to a filter. Is there any way to solve it? I want to read it as a space

[makulasailakshmi]

Good Morning Trainer,
Could you please explain How many times can we ZN expression in measures?

[premmbissht]

Hi Belle, how we can get the count of null values in every column level?

[being_royal_]

Can u show us window functions in calculation fields??

[RameshCh-mejm]

Very useful video thanks for sharing 🙂

[K_S_Harish]

Is applying a 0 value to every Null value in a numerical column recommended ?

[dikshachourasiya]

Its a Kind request, it would be better if the video is without background music.It is very irritating