God is in the details - Change the Header Position to TOP-

God is in the details-

I'm not sure this idiom is undertandable in English or not, anyways, what I'd like to say is if the detail is good entire sysytem should be good.

Of course this kind of idiom is not alwasy true, but I think this matches the case I explain today.

Here is a simple chart.

f:id:skn_0410:20160819064221p:plain

Now add Cutomer Category on Column.

f:id:skn_0410:20160819064616p:plain

Becasue we have multiple Bar charts on columns, we want to move the [Cutomer Segment] Header to the Top to narrow the distance from Top chart to the header.

f:id:skn_0410:20160819064840p:plain

 

Let's try to add same pill of [Custoemr Segment] on Columns.

f:id:skn_0410:20160819065518p:plain

The results looks like below.

f:id:skn_0410:20160819065624p:plain

We got headers on both top and bottom.

This is good, but little bit noisy.

So, we want to remove the header from bottom.

 

Let's try to hide header of the bottom.

f:id:skn_0410:20160819065815p:plain

End in this results.

Both headers are gone unexpectedly....

This does not work.

f:id:skn_0410:20160819065856p:plain

.

Ay other idea?

 

Yes, we can try to add other field.

Which field is good?   We have a clear condition requirement.

If the field has multiple values, it impact to the view itself. Then the field should have only one value.

Simply saying, we'd better add one dummy field, like this.

[Dummy_Header]

"A"

It's better to put string than numeric value because handling numeric value is more troublesome that string value.

Let's put this [Dummy_Header] into the columns at right side of [Custoemr Segment].

f:id:skn_0410:20160819071032p:plain

Looks good. Now uncheck "show header" of [Dummy_Heaser]

f:id:skn_0410:20160819072618p:plain

 

f:id:skn_0410:20160819071204p:plain

Yes, this is what we wanted.

 

This is good opportunity, so let's try some extreme cases.

f:id:skn_0410:20160819071811p:plain

 

f:id:skn_0410:20160819072024p:plain

You can see the right-end field's value is set as the bottom Header, and rest of fields' value are set as top headers with left side field as higher positioin.

 

Very samll TIPs, but better to have!  

Enjoy Tableau!

 

Tableau Public