7 ESSENTIAL Looker Studio HACKS EVERYONE Should Know!

[@LearnBI]

🚀 BECOME A BI ANALYST 🚀 Enroll in a certification program teaching you all of the skills and tools you'll need as an entry-level Business Intelligence Analyst. Your new career starts here 👉🏻 geni.us/bicsp

[@dakshbhatnagar]

The last one was super powerful 💯 Great Video

[@SDMJN-n6d]

Hello, thanks for your videos. Do you know if it is possible to have looker in self-hosted instead of the cloud ?

[@LearnBI]

Looker can be self hosted but I don’t think Looker Studio can.

[@yasironvideo]

Thank you so much for such an informative video. I wonder if you could help me solve this...... "In google studio it is very common to make a bar chart of a geographical level we want to show by default (for example country wise number of polio cases) and at the same time we also give a filter (a drop down control) on the dashboard to let the the user select a particular country to filter all the charts on the page for that country. Now once a user selects a country using the given dropdown the country bar chart shows only one bar (the selected country) which looks very odd, can we do something to change this bar chart to become below country level (for example state wise number of polio cases) so that it shows state wise polio cases of the selected country and when no country is selected (or all countries are selected) it shows country wise number of polio cases. Ah, I hope I was able to covey it properly.

[@LearnBI]

In short, no. Not possible. You cannot activate a drill down using a filter control.

[@yasironvideo]

@LearnBI ok, thank you so much for the quick response.

[@manuelespitia10]

Hi! Almost found what I was looking for in this awesome video, thanks. Do you know if there’s a way to use a data range control as a calendar table? This is, that it uses two different date columns to filter? Both columns are in the same blended table. Thanks in advance.

[@LearnBI]

A date filter control applies the date range to whichever date field is selected in the widget of each visualisation. So it can apply to more than one date. But each visualisation cannot have more than one date included. Hope this helps!

[@manuelespitia10]

@@LearnBI thanks, it helps!! Just one more question: for a table visual that has the date columns in it… is it possible to filter it in that way using a date range control?

[@LearnBI]

A date range filter control will apply the date range to any visualization that has a date field included in the query. It will use that date field to filter the rows in the result.

[@zaymarhenriquez-sedra2720]

Thanks! can I adjust the height of the rows on a pivot table?

[@LearnBI]

Did you mean to type your comment into the google search bar?

[@benjaminbluma2245]

Adam, great channel and content, and yeah those hacks are really useful! Thank you.

[@LearnBI]

You’re welcome!

[@alexis.jacobo.drums14]

Hi! Thanks for sharing. I have a question related to performance: I'm using Windsor AI to input my data from Google Ads and Meta Ads into Looker Studio but it makes editing reports terrific (in a bad way), is there anyway to make it run faster?

[@LearnBI]

I’d recommend contacting Windsor support

[@asmaryadia4846]

Hi, amazing video I have a question, how to make differen color to the text in different category. If normal it be green text, but if abnormal be red text, automaticly?

[@LearnBI]

You would need to use conditional formatting. Is only available for certain visualization types so check the settings of your visualization to see if it’s available.

[@asmaryadia4846]

thanks so much @@LearnBI

[@JoeTurk-q8e]

Very helpful! Thank you

[@LearnBI]

You're welcome!

[@MiguelGomez12345]

I need it the last one thanks

[@AmritaGhosh-w5b]

How to use conditional formatting on a field based on a different field?

[@LearnBI]

All of the conditional formatting options are there in the interface (Setup tab). If you can’t see them, they don’t exist.

[@helenandersson5097]

Hi Adam! Great video! I have another question: when I am copying a report because I want one similar for another client, something strange happens, namely that when I am changing data source in the copy it applies in the origin report as well. How can I prevent that to happen? I would be more than happy for an answer as I am working with this now. :D Happy New Year!

[@LearnBI]

As far as I'm aware, that isn't the normal behaviour when duplicating reports. What I would suggest after duplicating is to delete all data sources before adding new ones.

[@hasanmougharbel8030]

Hey there, Glad to discover your channel. I have a simple question as an sql newbie. Do you advice me to produce report by using SQL in-built reporting services or should i consider crystal reports for any better features? Thanks for taking care of this.

[@LearnBI]

If you are going to be working almost exclusively with SQL then a SQL-centric reporting tool might be fine but if you’re going to be working with a variety of different data sources, you’ll probably want to consider something more versatile like Tableau, Power BI, Data Studio etc.

[@onlyhummingalong]

Can you help me determine why the new rows in the Google sheet do not appear in my chart? I reconnected, refreshed, etc

[@LearnBI]

I’d recommend joining a Facebook group and asking there. The comments of a KZbin video isn’t the right place to resolve issues like this.

[@ayushiverma2033]

How to freeze header in looker studio dashboard?

[@md.taifuranam7904]

How I will data font size increase in looker studio it is very little.

[@LearnBI]

In the style tab to the right of the report when the visualization is selected.

[@CaribouDataScience]

How can I import Excel spreadsheets?

[@LearnBI]

You can’t, you need to save Excel as CSV and use the file upload connector. Or you could upload to Google Drive and save as Google Sheet and use that connector.

[@CaribouDataScience]

@@LearnBI thanks

[@LearnBI]

You’re welcome

[@sincerelycin]

So helpful

[@scissorspaperpaul]

Terrific 🎉

[@scottf0623]

paste styles only! thank YoU!

[@LearnBI]

You're welcome!

[@msb3064]

How do we group filter on page 1 with a graph on page 2

[@LearnBI]

support.google.com/looker-studio/answer/6291066?hl=en

[@Cricket_reactions_1]

i want to create a comparison report of conversion rate between new users and returning users. Is this possible? I mean how many users converted from new users count and how many converted from returning user count. Please help

[@LearnBI]

I’m assuming you’re talking about Google Analytics? That kind of report is possible but much too complicated to explain in the comment of a KZbin video. I’d suggested joining a Looker Studio Facebook group and asking your question there instead.

[@Cricket_reactions_1]

Could you please make a video on this

[@LearnBI]

It’s not something a lot of people are looking for so probably not.

[@Cricket_reactions_1]

Actually one our client has asked us for such report. But it seems quite difficult for me to figure out.

[@LearnBI]

Like I said, try asking in a Facebook group. Good luck!

[@alexandros2024]

Ciao, non trovo nessuno in grado di modificare il colore degli istogrammi in un grafico di datastudio, in base al valore positivo o negativo. Esempio blu se positivo, rosso se negativo. Tu ci riesci ?

[@LearnBI]

Non è possibile applicare la formattazione condizionale a un semplice istogramma. Quello che potresti provare e utilizzare è un grafico a cascata dalle visualizzazioni della community, ma di solito viene utilizzato solo per casi d'uso specifici. Oppure usa una tabella e applica la formattazione condizionale.

[@brysondigital]

Any way to put a password on a report url ?

[@LearnBI]

No not in a url. There are workarounds for adding a password using parameters and filters but not directly in the url. Not sure why you’d want to do that anyway.

[@jackgaleras]

Does anyone know how to export graphics in looker studio (png -jpg)

[@LearnBI]

What do you mean by graphics?