Hide Column in PIVOT Table Chart

[vr_2020]

Hi,

I want to hide both “Order Items Shipped Date” and “Order Items Count”  as highlighted in Table Chart (two dimensions and one measure) with one dimension pivoted . I mean the complete row should not be visible as shown in “TO:” section as follows

FROM:

TO:

Tried “Hide from Visualization” for a specific column in Explore → Data section , but that doesn’t serve my purpose.

Any option(s) to achieve the above said scenario please?

[Dawid]

What do you mean it doesn’t serve your purpose? What’s the output of what you’re doing right now?

[leobardor]

Hi Vr 2020,

I would like to share that there is a hacky way to achieve this:

1.- Visit https://emptycharacter.com/ and copy the empty char

2.- Paste this content  in the measure label -edit settings:

(For instance)Saved as a look:

Hopefully, it will help in others looker fields too

#empty #char #blank #looker #whitespace #field #label #white

Best regards,

Leo

[srit]

Can we remove blank title row and can we remove/restrict/disable sort order change icon?

[vr_2020]

@Dawid - My bad, here is the screenshot. To answer your question, I tried the following option:

In Explore → Data section trying to hide a measure column by clicking gear icon and “Hide from Visualization” .When I do this,  Visualization section shows error with Empty Pivot(s).

[Dawid]

if you hide the only measure you have in your Data Table, you won’t have anything to Pivot.. 

[vr_2020]

@leobardor  - Tried empty char. It works. Thanks. I am quite new to Looker and to this Looker community. Could you please let me know how do we send a request to Looker Product team for this kind of feature/options to get added in Looker? 

[vr_2020]

@Dawid  - Yes, that’s how it works for my scenario (two dimensions and one measure)

[leobardor · Accepted solution]

@leobardor  - Tried empty char. It works. Thanks. I am quite new to Looker and to this Looker community. Could you please let me know how do we send a request to Looker Product team for this kind of feature/options to get added in Looker? 

Hi Vr,

This is the post where we can find more information about how contact looker engineering support.

https://community.looker.com/getting-started-1006/feature-requests-how-your-feedback-makes-looker-be...

If the answer above was right for you, it will be a good idea that you marked it as the answer to this topic.

Have a nice week!

Leo

[vr_2020]

@leobardor - Thanks for the engineering support link. emptycharacter hacky way is really good. I marked it as answer.

However , I am thinking out loud in terms of data security by introducing this type of external link https://emptycharacter.com/ in my looker project. Not sure what’s in there in Copy to Clipboard.

[srit]

@vr_2020 Are you able to remove the blank row on top of the report where column titles exists before?