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

[@equiwave80]

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

[@sqlbelle]

Thank you Deepak!

[@vickybisht5744]

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

[@sqlbelle]

Thank you so much for your kind comment, Vicky!

[@xiao_wang]

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

[@jimmypaterson7515]

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?

[@ravinduabeygunasekara833]

Great descriptive video. Thanks a lot for doing this

[@Azxios93]

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

[@sqlbelle]

Sounds great! Glad you were able to find it in the video!

[@yallababus164]

​@@sqlbellesame zn not works in last example with countd function ? How to show zero or null in place of blank(no "abc" ) empty places

[@Aayisha-d2t]

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.

[@thanugamage7576]

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

[@tracieh4039]

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?

[@srem1971]

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

[@sqlbelle]

By default when you have a continuous date axis, you should be able to plot the line graph. I may be misunderstanding your question though?
If it's helpful, I have a video on dates - the continuous dates might be what you're needing? ruclips.net/video/ufhNJmYrVhs/видео.html

[@srem1971]

@@sqlbelle Great, thanks for your quick response!

[@shreekantgosavi4726]

So much helpful
Thanks sqlbelle

[@sqlbelle]

Great to hear, thank you Shreekant!

[@makulasailakshmi]

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

[@Data_Mom]

easy explanation with good examples, thanks for sharing

[@sqlbelle]

Thank you so much for your kind comment, Pooja! Glad you are finding the tutorial helpful!!

[@pankajmathur9]

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

[@sqlbelle]

Thank you Pankaj! Would you please be able to remind me what about projects you would be interested in?

[@being_royal_99]

@@sqlbelle u can take a sales project which can give us idea of start to end.

[@chaqmedia8921]

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

[@bv9672]

Thank you so much for sharing this.🤩

[@sqlbelle]

You are welcome :)

[@anubhavkumr7441]

Great explaination.

[@sqlbelle]

Thank you Anubhav! Happy to hear you found the tutorial helpful!

[@RameshCh-me8jm]

Very useful video thanks for sharing 🙂

[@sqlbelle]

Thank you Ramesh!

[@susanbenson4941]

Brilliant. Thank you.

[@NishantKumar-tl4wy]

Thanks!! It helped a lot

[@sqlbelle]

Thank you Nishant!

[@premmbissht6873]

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

[@sqlbelle]

Hello Premm,
Do you mean if you were creating a data profile based on your data source? Depending on what you need to do, you could consider looking at Tableau Prep if you want a quick snapshot or explore your data? Here is a possible reference: help.tableau.com/current/prep/en-gb/prep_explore.htm#see-the-distribution-of-values-or-unique-values
Donabel

[@vdn5716]

Very very useful..

[@sqlbelle]

Glad to hear you found it useful VDN!

[@cococnk388]

merci

[@being_royal_99]

Can u show us window functions in calculation fields??

[@sqlbelle]

Thank you Faisal, for sure! My next video I am planning uses all table calcs in calculated fields. In the meantime though please feel free to check out my table calculation video ruclips.net/video/3_DeQdE25Bc/видео.html ... the small multiples video also uses table calculations ruclips.net/video/kWZoa3UfbVs/видео.html as well as the certification prep series ruclips.net/video/Sf1aJoKpXfE/видео.html

[@being_royal_99]

@@sqlbelle thank you..
And I watched almost all the tableau vedios of yours, its better for understanding and giving so much tips.
And could you please make a detailed vedio on dashboard components

[@K_S_Harish]

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

[@sqlbelle]

Hello Harish - no, this still needs to be evaluated because zero and NULL mean different things. However, if you will be doing math operations - you need to handle exceptions because your results will be way off if you leave the NULLs as they are and *still* use them in the expressions

[@mtgmtgyoutube221]

Thanks a lot.

[@sqlbelle]

Thanks MTG!

[@apuroop.mahadev]

Thank you

[@sqlbelle]

Thanks Apuroop!

[@shafaoddinjavadi9809]

danke

[@dikshachourasiya9749]

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

[@sqlbelle]

Thanks. Appreciate your feedback.