Subscribed unsubscribe Subscribe Subscribe

It's equipped with One Check/Uncheck - Show Blank Cells in the Table

Sometimes easy view takes 100 of steps to be created.

exceltableau.hatenablog.com

But somtimes it's done only by one Check/Uncheck.

exceltableau.hatenablog.com

 

I got a request that he wants to show the "Blank" Cells in the table.  

He wanted to show the table like below.

f:id:skn_0410:20160817052608p:plain

This looks good, but when we filtered 4th Item of " 6" Cubicle Wall ***"  as an example, the table becomes like below.

f:id:skn_0410:20160817052744p:plain

It seems good at a glance, but you can see it excludes Null Value and doesn't show Yr2010 data in the column.

So, the question was how to show this colum in the table.

f:id:skn_0410:20160817052947p:plain

 

I tried to use the formula which can put "0" in the table.

[Sales (ZN,lookup)]

zn(lookup(sum([Sales]),0))

 

f:id:skn_0410:20160817053158p:plain

But when I filter this item only, the view still hides Yr 2010.

f:id:skn_0410:20160817053415p:plain

 

The answer was quite easy AS LONG AS you know it.

Check "Show Empty Columns"

f:id:skn_0410:20160817053636p:plain

 

It still does not show the missing column like this.

f:id:skn_0410:20160817053822p:plain

That's the reason I was confused, but one more check, which is "show missing value".

f:id:skn_0410:20160817053936p:plain

 

If the column is the dimensioin which is not "Date" related, without checking "show missing value", you can display blank cells like this.

f:id:skn_0410:20160817054210p:plain

One thing we need to pay attention is "Filtering"

f:id:skn_0410:20160817054600p:plain

At this point, we only filter "Product Name".

But when you click the triangle of Column of "Product Container", (right corner of the pill)

and select Filter, 

f:id:skn_0410:20160817054804p:plain

It brings below window.

f:id:skn_0410:20160817054835p:plain

When you click OK, the table changed as below unexpectedly.

f:id:skn_0410:20160817054937p:plain

We can remove the filter to show all the items or we can select items which we want to show just as usual filtering fuctions.

f:id:skn_0410:20160817055710p:plain

 

There are still many things we need to learn.

Enjoy Tableau !!

 

public.tableau.com