Very good explanations. I am stuck trying to figure out though how to add unobserved categories altogether though, for example if people chose options A, C or D for an answer. How do I get Tableau to realize option B was a possible option.
I need to return 0 however I’m working with a dimension not a measure. For example I am counting distinct(countd) order numbers to sum the total orders per each sales rep. Where the data is blank/no orders I need to show 0. Any help would be greatly appreciated.
@@TableauWeston i'm still having problems with this. Right now I'm using a calculated field, CountD(order #) to show total orders by salesman. Order# is a dimension/string. if there is no order# the data is completely is blank for that field, but in the calculated field CountD(order #) it is showing the salesman with a 1 instead of 0. I've tried this ZN(LOOKUP(COUNTD([Order #]),0)) and I've tried IFNULL but that won't work when using a string and an integer.
Good explanation, but it doesn't work for my case. For example, i have dataset with only 2 colums like this: date value 01.01.2020 50,00 01.04.2020 65,00 01.07.2020 75,00 01.11.2020 85,00 01.01.2021 100,00 Then I make viz like: Columns: 'QUARTER(date)' - discrete Rows: 'YEAR(date)' - discrete pills 'value' on the Text After that I get table where I have missing value for 'value' for Q2 2021, Q3 2021, Q4 2021. I tried your method with 'ZN(LOOKUP(SUM([value]), 0))' but it doesn't work for me. Also I tried to change compute using, but the same. Any ideas how to win?
@@temnikoff I am also facing similar issue, where end of data is not defined,(last 4 months i.e sep, oct, nov, dec are still empty) any solution how we can proceed is that case. I want default value till dec.
@@ashwaniyadav7356 actually i have no idea. I tried to add 31/12/2030 in my table and zn() in tableau show 0. But then I tried to filter date as 'date > today() = false' and ZN() didn't work again. May be the index() and filterring with it helps us but I didn't try it else.
This is a really great help for me. I was looking for this solution for months. Thank you very much.
Thank you very much. It helped me a lot . Love you from INDIA 🇮🇳
You are too kind.
This has been very helpful, thank you for explaining it so clearly !
Glad it was helpful! Thank you for watching.
post replacing zero, not able to do percentage of of column total or any % total
This really help me out, just what I needed! thank you
I'm so glad! Thanks for watching. Come back again.
I am not able to input data into the data values area, how can I rectify that?
If don't have Jan month and no hours how can we disaply Jan and wherever I see Jan month how to show zero ?
What if the January month doesn't have any data I mean '0' will this still work fine?
Very good explanations. I am stuck trying to figure out though how to add unobserved categories altogether though, for example if people chose options A, C or D for an answer. How do I get Tableau to realize option B was a possible option.
@@TableauWeston I started thinking along those lines, perhaps with a blend or a join. I am gonna try that.
I need to return 0 however I’m working with a dimension not a measure. For example I am counting distinct(countd) order numbers to sum the total orders per each sales rep. Where the data is blank/no orders I need to show 0. Any help would be greatly appreciated.
Weston Palmer there is no data so it’s blank and not actually null. Does tableau handle that the same way?
@@TableauWeston i'm still having problems with this. Right now I'm using a calculated field, CountD(order #) to show total orders by salesman. Order# is a dimension/string. if there is no order# the data is completely is blank for that field, but in the calculated field CountD(order #) it is showing the salesman with a 1 instead of 0. I've tried this ZN(LOOKUP(COUNTD([Order #]),0)) and I've tried IFNULL but that won't work when using a string and an integer.
Thanks for help very good understanding
Glad it helped
v nice pls make more such vid..thanks
Great Tutorial...but please can you make it more frequent? Thanks
... Not sure why you went some complicated way on the second graph part. All I wanted to see what that feb blank say "0.0%" or "0"
Good explanation, but it doesn't work for my case.
For example, i have dataset with only 2 colums like this:
date value
01.01.2020 50,00
01.04.2020 65,00
01.07.2020 75,00
01.11.2020 85,00
01.01.2021 100,00
Then I make viz like:
Columns: 'QUARTER(date)' - discrete
Rows: 'YEAR(date)' - discrete
pills 'value' on the Text
After that I get table where I have missing value for 'value' for Q2 2021, Q3 2021, Q4 2021.
I tried your method with 'ZN(LOOKUP(SUM([value]), 0))' but it doesn't work for me. Also I tried to change compute using, but the same.
Any ideas how to win?
@@TableauWeston wow! Such a quick answer! Thanks a lot.
@@temnikoff I am also facing similar issue, where end of data is not defined,(last 4 months i.e sep, oct, nov, dec are still empty) any solution how we can proceed is that case. I want default value till dec.
@@ashwaniyadav7356 actually i have no idea. I tried to add 31/12/2030 in my table and zn() in tableau show 0. But then I tried to filter date as 'date > today() = false' and ZN() didn't work again. May be the index() and filterring with it helps us but I didn't try it else.
Thank You very much! Very helpful
sorry to say but it didnt clear my concept