Тёмный

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

sqlbelle
Подписаться 120 тыс.
Просмотров 49 тыс.
50% 1

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.

Наука

Опубликовано:

 

22 окт 2020

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 51   
@equiwave80
@equiwave80 2 года назад
Thanks for this short but very useful video!!! The ZN function is something that will be very useful in any data analysis.
@sqlbelle
@sqlbelle 2 года назад
Thank you Deepak!
@xiao_wang
@xiao_wang 4 месяца назад
Awesome content. Could you do a session of scaffolding method to deal with null dates?
@ravinduabeygunasekara833
@ravinduabeygunasekara833 Год назад
Great descriptive video. Thanks a lot for doing this
@vickybisht5744
@vickybisht5744 2 года назад
Your way of explaining everything is awesome. I really like they way you teach everything
@sqlbelle
@sqlbelle 2 года назад
Thank you so much for your kind comment, Vicky!
@thanugamage7576
@thanugamage7576 Год назад
Please do a video on how to handle data source changes such as field name changes. You are awesome.
@susanbenson4941
@susanbenson4941 Год назад
Brilliant. Thank you.
@Azxios93
@Azxios93 3 года назад
Thank you for sharing, the ZN Function is the one I'm looking for
@sqlbelle
@sqlbelle 3 года назад
Sounds great! Glad you were able to find it in the video!
@yallababus164
@yallababus164 10 месяцев назад
​@@sqlbellesame zn not works in last example with countd function ? How to show zero or null in place of blank(no "abc" ) empty places
@Data_Mom
@Data_Mom 3 года назад
easy explanation with good examples, thanks for sharing
@sqlbelle
@sqlbelle 3 года назад
Thank you so much for your kind comment, Pooja! Glad you are finding the tutorial helpful!!
@bv9672
@bv9672 2 года назад
Thank you so much for sharing this.🤩
@sqlbelle
@sqlbelle 2 года назад
You are welcome :)
@jimmypaterson7515
@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?
@shreekantgosavi4726
@shreekantgosavi4726 3 года назад
So much helpful Thanks sqlbelle
@sqlbelle
@sqlbelle 3 года назад
Great to hear, thank you Shreekant!
@travellerclick2558
@travellerclick2558 Год назад
thank you for sharing
@makulasailakshmi
@makulasailakshmi 2 года назад
Good Morning Trainer, Could you please explain How many times can we ZN expression in measures?
@anubhavkumr7441
@anubhavkumr7441 3 года назад
Great explaination.
@sqlbelle
@sqlbelle 3 года назад
Thank you Anubhav! Happy to hear you found the tutorial helpful!
@NishantKumar-tl4wy
@NishantKumar-tl4wy 2 года назад
Thanks!! It helped a lot
@sqlbelle
@sqlbelle 2 года назад
Thank you Nishant!
@RameshCh-me8jm
@RameshCh-me8jm 2 года назад
Very useful video thanks for sharing 🙂
@sqlbelle
@sqlbelle 2 года назад
Thank you Ramesh!
@tracieh4039
@tracieh4039 11 месяцев назад
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?
@pankajmathur9
@pankajmathur9 3 года назад
Thank you once again Belle. It is a request belle, kindly make some videos on projects also. :)
@sqlbelle
@sqlbelle 3 года назад
Thank you Pankaj! Would you please be able to remind me what about projects you would be interested in?
@being_royal_99
@being_royal_99 3 года назад
@@sqlbelle u can take a sales project which can give us idea of start to end.
@vdn5716
@vdn5716 3 года назад
Very very useful..
@sqlbelle
@sqlbelle 3 года назад
Glad to hear you found it useful VDN!
@mtgmtgyoutube221
@mtgmtgyoutube221 3 года назад
Thanks a lot.
@sqlbelle
@sqlbelle 3 года назад
Thanks MTG!
@chaqmedia8921
@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
@cococnk388
@cococnk388 Год назад
merci
@srem1971
@srem1971 3 года назад
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
@sqlbelle 3 года назад
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? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ufhNJmYrVhs.html
@srem1971
@srem1971 3 года назад
@@sqlbelle Great, thanks for your quick response!
@apuroop.mahadev
@apuroop.mahadev 2 года назад
Thank you
@sqlbelle
@sqlbelle 2 года назад
Thanks Apuroop!
@premmbissht6873
@premmbissht6873 3 года назад
Hi Belle, how we can get the count of null values in every column level?
@sqlbelle
@sqlbelle 3 года назад
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
@shafaoddinjavadi9809
@shafaoddinjavadi9809 Год назад
danke
@K_S_Harish
@K_S_Harish 2 года назад
Is applying a 0 value to every Null value in a numerical column recommended ?
@sqlbelle
@sqlbelle 2 года назад
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
@being_royal_99
@being_royal_99 3 года назад
Can u show us window functions in calculation fields??
@sqlbelle
@sqlbelle 3 года назад
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-3_DeQdE25Bc.html ... the small multiples video also uses table calculations ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kWZoa3UfbVs.html as well as the certification prep series ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Sf1aJoKpXfE.html
@being_royal_99
@being_royal_99 3 года назад
@@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
@dikshachourasiya9749
@dikshachourasiya9749 2 года назад
Its a Kind request ,it would be better if the video is without background music.It is very irritating
@sqlbelle
@sqlbelle 2 года назад
Thanks. Appreciate your feedback.
Далее
Yeni Özbək Mahnisi Yoxsa Vefali Reqsi? 😍
00:36
Просмотров 2,2 млн
ZN Function in Tableau: Replace Nulls with Zeros
6:48
Сложная распаковка iPhone 15
1:01
Просмотров 14 тыс.