7 ESSENTIAL Looker Studio HACKS EVERYONE Should Know!

[@LearnBI]

🚀 BI CAREER STARTER PROGRAM 🚀 A fully mentored certification program taking you from ZERO TO BI ANALYST IN 12 WEEKS. Your new career starts here 👉🏻 geni.us/bicsp

[@dakshbhatnagar]

The last one was super powerful 💯 Great Video

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

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

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

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

[@benjaminbluma2245]

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

[@LearnBI]

You’re welcome!

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

[@MiguelGomez12345]

I need it the last one thanks

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

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

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

[@JoeTurk-q8e]

Very helpful! Thank you

[@LearnBI]

You're welcome!

[@ayushiverma2033]

How to freeze header in looker studio dashboard?

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

[@scottf0623]

paste styles only! thank YoU!

[@LearnBI]

You're welcome!

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

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

[@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!

[@jackgaleras]

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

[@LearnBI]

What do you mean by graphics?

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

[@scissorspaperpaul]

Terrific 🎉

[@sincerelycin]

So helpful

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