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?
Solved! Go to 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
What do you mean it doesn’t serve your purpose? What’s the output of what you’re doing right now?
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
Can we remove blank title row and can we remove/restrict/disable sort order change icon?
@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).
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)
@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
@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.
@vr_2020 Are you able to remove the blank row on top of the report where column titles exists before?