1 2 Previous Next 18 Replies Latest reply on Jul 17, 2017 1:46 AM by PREUTTI PUAWADE

# Data cannot show in table

Hi tableau community,

I got problem to show data in the table. Here is my original table. Please focus on yellow arrow.

I try to summary table to put calculation on as
- DPPM which is NDR Qty divided by Input * 1,000,000

- NDR Qty which is number of NDR

- Input which is sum of NDR,DR,Sum .

So my table will be like this.

Problem is like in column of "Trial" in "14-07-17" group, Input does not shown from my understanding it should have 207 as my input.

Also same thing in "Normal" of "11-07-17" , I should have 352 as my Input but it does not show up. I'm try to find answer but just don't know

how to explain this in just a few words so I put it as my question to ask for help.

• ###### 1. Re: Data cannot show in table

Preutti,

It might possibly be due to nulls in your data set (14-07-17 has a null for Trial for NDR).

You could try to convert them to zeros by using the ZN() function:

[Input]:

ZN([DR])+ZN([NDR])+ZN([Pass])

• ###### 2. Re: Data cannot show in table

Hi SWAROOP.GANTELA,

Thank for your advice. I think it should very close to help me. However, I have try zn function and it's still not showing as my expectation.

Let's me share the view of report I have and what I want to have. Also I've attached twbx file, could you please teach me how to use ZN function effectively?

Thank you in advance.

• ###### 3. Re: Data cannot show in table

This is not an issue that will be solved with ZN. In the image below, you can see that there is no data for the NDR flag in Trial. So, when there is no data, you cannot expect it to show a value.

If you need a solution for this, you need to ensure that you have a record for all the field combinations with a zero value.

1 of 1 people found this helpful
• ###### 4. Re: Data cannot show in table

Hi , that is the hardest part for me. Any code to suggest?

• ###### 5. Re: Data cannot show in table

Hi,

As per my understanding on your question I have modified it as below

Please check if you are looking for something as above.

1 of 1 people found this helpful
• ###### 6. Re: Data cannot show in table

I would append data with zeroes for all the combinations. Usually, I do it using SQL. I have highlighted it in the attached file. I may not have put all combinations, but hope you get it.

• ###### 7. Re: Data cannot show in table

Hi there,

Almost there still have some error in some cells. Any more suggest?

• ###### 8. Re: Data cannot show in table

Hi,

I'm sorry. I have limited in SQL skill. So looking for an solution that work on Tableau.

Thank you anyway.

• ###### 9. Re: Data cannot show in table

Did you look at the Excel file I attached? You need to zero fill that way for all the combinations.

1 of 1 people found this helpful
• ###### 10. Re: Data cannot show in table

Yes sir, I looked at your excel file already. However, my actual data source is not excel. It's actually a data table Hive server. So it's difficult for me to put zero that way when query data. Sorry and thank you again.

• ###### 11. Re: Data cannot show in table

You need to do a cartesian join using the distinct values of Product, Family, Normal-Trial, FLAG, and End-Date. So, check out how you can do it on Hive. Hope this helps.

https://stackoverflow.com/questions/37710290/how-to-achieve-cartesian-product-joins-in-strict-mode-in-hive

1 of 1 people found this helpful
• ###### 12. Re: Data cannot show in table

Hi,

Let's me consult with my IT support team for your method. I'm just blank for what it is. And let's me confirm. Is that the only way that can solve my problem or is there any work around on Tableau.

• ###### 13. Re: Data cannot show in table

By the way, "Normal-Trial" column is the one I have made it up on Tableau. Original Hive table has no this feature. What should i do?

• ###### 14. Re: Data cannot show in table

Yes, that solution will work in all scenarios, otherwise you may see solutions that work in some cases and not in the other.

1 2 Previous Next