Solved

Hide Column in PIVOT Table Chart


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?

icon

Best answer by leobardor 9 May 2022, 22:44

View original

8 replies

Userlevel 7
Badge +1

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

Userlevel 2

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

 

@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).

 

 

 

Userlevel 7
Badge +1

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

@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? 

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

Userlevel 2

@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.

 

 

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

@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.

Reply