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.
This has been very helpful, thank you for explaining it so clearly !
Glad it was helpful! Thank you for watching.
Thank you very much. It helped me a lot . Love you from INDIA 🇮🇳
You are too kind.
This really help me out, just what I needed! thank you
I'm so glad! Thanks for watching. Come back again.
post replacing zero, not able to do percentage of of column total or any % total
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 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?
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.
Great Tutorial...but please can you make it more frequent? Thanks
Thanks for help very good understanding
Glad it helped
v nice pls make more such vid..thanks
Thank You very much! Very helpful
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.
... 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"
sorry to say but it didnt clear my concept