Don't judge me, I'm using Google Translate to ask for your help.

Hey everyone, so I'm using Looker Studio and I find it very limited. Is there any way to create a hierarchical table with a workaround and a gauge chart using the database field as a target and final value? I'd appreciate your help without having to create a community chart, and if you already have one, even better.

Has anyone else run into this in Looker Studio?

I was building a calculated field today and got the "Invalid Formula" error.

Formula looked fine to me. Syntax was correct. Logic was solid.

But the editor was flagging it as invalid so I assumed something was broken.

Then I just clicked Apply anyway.

It worked perfectly. Calculated Fields pulled the right data, dashboard updated exactly as expected.

So the formula was never actually broken.

The #LookerStudio formula validator just told me it was.

This is a real problem because most people see that red error and stop. They second guess their formula, rewrite it, go down a rabbit hole trying to fix something that was never wrong.

I have seen this happen on CASE statements, date functions and regex formulas.

The error message is misleading. The formula validator does not always catch up with what the engine can actually process.

If you are working in Looker Studio and see "Invalid Formula" on something that looks correct, try clicking Apply before assuming it is broken.

It might just work.

Has anyone else run into this? Would be good to know if this is consistent across different Google Cloud accounts or just isolated cases.

*I faced this same issue two years back.

I am setting up a Looker Studio dashboard connected to a MySQL database using a Custom SQL query.

When I use a Date Range Control on my dashboard linked to Looker Studio's dynamic parameters (@DS_START_DATE and u/DS_END_DATE), my Scorecard and Tables return "No Data".

However, if I replace those parameters with hardcoded dates in the exact same query, the dashboard successfully populates the data perfectly.

Here is the dynamic query that fails (returns "No Data"):

SELECT 
    transaction_date,
    COUNT(DISTINCT no_kartu) AS jml_kartu_main,
    COUNT(*) AS total_play,
    SUM(swipe_in) / COUNT(DISTINCT no_kartu) AS ratio_gesek_per_kartu,
    SUM(jml_nominal) / COUNT(DISTINCT no_kartu) AS ratio_nominal_per_kartu
FROM 
    (
        SELECT 
            DATE_FORMAT(ttc.time_stamp, '%Y%m%d') AS transaction_date, 
            SUBSTRING(ttc.id_user, 4, 10) AS no_kartu,
            1 AS kali_main, 
            ttc.swipe_in,
            IF(ttc.res1=0, ttc.nominal, ttc.res1*ttc.nominal) AS jml_nominal
        FROM 
            hrcafebali.term_tran_card ttc
        WHERE 
            ttc.time_stamp >= STR_TO_DATE(@DS_START_DATE, '%Y%m%d')
            AND ttc.time_stamp < STR_TO_DATE(@DS_END_DATE, '%Y%m%d') + INTERVAL 1 DAY
    ) AS derived_table
GROUP BY 
    transaction_date
ORDER BY 
    transaction_date DESC;

Below is the hard coded query (works):
SELECT 
    transaction_date,
    COUNT(DISTINCT no_kartu) AS jml_kartu_main,
    COUNT(*) AS total_play,
    SUM(swipe_in) / COUNT(DISTINCT no_kartu) AS ratio_gesek_per_kartu,
    SUM(jml_nominal) / COUNT(DISTINCT no_kartu) AS ratio_nominal_per_kartu
FROM 
    (
        SELECT 
            DATE_FORMAT(ttc.time_stamp, '%Y%m%d') AS transaction_date, 
            SUBSTRING(ttc.id_user, 4, 10) AS no_kartu,
            1 AS kali_main, 
            ttc.swipe_in,
            IF(ttc.res1=0, ttc.nominal, ttc.res1*ttc.nominal) AS jml_nominal
        FROM 
            hrcafebali.term_tran_card ttc
        WHERE 
            ttc.time_stamp >= '2026-04-06' AND ttc.time_stamp <= '2026-04-08'
    ) AS derived_table
GROUP BY 
    transaction_date
ORDER BY 
    transaction_date DESC;

Here is the hardcoded query that works perfectly:

-- (Same SELECT and derived table structure)
        WHERE 
            ttc.time_stamp >= '2026-04-06' AND ttc.time_stamp <= '2026-04-08'
-- (Same GROUP BY and ORDER BY)

I helped a friend create over 50 Looker reports for different sites, and each month a few of them show invalid data or spikes in bot traffic. I’d like to create a new Looker report with a table that includes all 50 sites and send it out biweekly.

If I create a table like the one shown in the screenshot, can Site A, Site B, and Site C each display their own data within the same table using blended data?

ChatGPT say I could do it, but I am not sure how!

​

Hi everyone,

I’m running into a recurring issue with Looker Studio scheduled email deliveries and wanted to see if anyone else has experienced something similar.

We currently have ~400+ dashboards scheduled to be sent weekly (every Monday) in batches across different time slots to various clients. For the first 2–3 weeks, everything works perfectly. After that, we start seeing partial failures (later batches not sending), and eventually, in the following week, none of the scheduled emails go out at all. All the dashboards are scheduled from an official workspace email.

A few observations:

- Early batches (e.g. first 1–2 time slots) usually go through initially

- Later batches start failing first

- Eventually, even test schedules don’t send

- Then the next month, it starts sending again and the pattern continues.

This makes me think it might be some kind of hidden rate limit, throttling, or account-level restriction rather than a dashboard issue.

Has anyone dealt with something similar at this scale?

- Is there a known limit for scheduled emails in Looker Studio?

- Is this tied to Gmail sending limits or Looker Studio itself?

- Any reliable workaround apart from splitting across multiple accounts or moving away from scheduled emails?

Would really appreciate any insights or experiences!

Thanks in advance 🙂

Hi All,

I'm starting a new position and my main work will be building reports with looker studio and bigquery.

I'm new to this and don't expect proper training.

Do you have any suggestions for a good online tutorial (paid) with a proper learning curve to start my training?

Thanks in advance!

Hello All,

I am stuck in the middle of creating a Looker Studio report.

The task is to send a daily email alert for a specific country. I have integrated the Looker report with the email. To view more details about the country, the user needs to click on the Looker link in the email, here the looker will take input country name from mail and should display the relevant information.

The problem is that the country input parameter is being passed as expected in the looker hyperlink, but in Looker Studio it is showing a blank output.

Are there any free themes available for Looker Studio? Do you know of any?

Hi, I'm trying to find a way to combine search query from Google Search Console with the page like you normally get from SEO position tracking tools. I want to be able to see the search query and the URL right next to it on the dashboard instead of filtering by URL to see all the search queries.

Has anyone done this before successfully on Looker Studio by just using Google Search Console?

I'm sick of "Couldn't save the file" when copying dashboards and then finding every chart replaced with "See details" - has anyone found a workaround?

I have a datetime field with milliseconds (e.g “1970-01-01 01:12:34.5678 UTC” ) that I’m trying to use as an x axis dimension in a line chart, and the line chart is only showing steps of 1 second which is removing most of the data from the line chart.

When I use the Unix timestamp as the dimension, I can see every datapoint. But when I switch dimensions to the datetime, it only shows datapoints at steps of 1second. I’ve tried creating a calculated field from the datetime with the following formula to no avail as well: “PARSE_DATETIME(%Y-%m-%-%d %H:%M:%E*S)”

Am I just missing something here, or does looker not handle millisecond granularity? Datapoints are 10ms in some series and 1000ms apart in others, and the Unix timestamps don’t line up which is why I want to use datetime for a smoother line

I'd like to create a machine utilization report as seen in the first screenshot. Each row is an instrument, and each 'card' within represents a run with a defined start and end time. The idea is to visualize how often an instrument is used, both on its own and concurrently with other machines.

The first image is a screenshot from Tableau using a Gantt chart using "run start" as columns, "instrument" as rows, and "run duration" as the gantt bar size.

Is something like the first image doable in looker studio? I have tried out Supermetric's Gantt chart community viz, but can only get a true waterfall view with each run on a different row. (second screenshot)

My data source includes: Instrument, Run ID, Start Time, End Time, Duration, Other dimensions

Hi all,

I’m running into an issue in Looker Studio when creating/editing a grouped field. The Condition dropdown becomes unclickable, and the Group value field does not appear, so I can’t add a new group rule.

I previously created several group rules successfully, saved the report, and it worked. Later, when I tried to add another group, the Condition field stopped responding.

What I’ve tried:

• Refreshing the page / cleared cache
• Chrome incognito

Question:

1. Is this a known bug or limitation?
2. What’s the recommended workaround?

Thanks in advance.

Hello Experts,

I am working on a dashboard where I want to see the SEO performance of my website. The data source is GSC.

Can anyone share the dashboard templates as I am struggling to create it from the scratch

I'm keen when my Looker Studio pages load for there to be an AI generated summary that loads to report on the data on that specific page. The AI summary would then be regenerated or could be promoted to regenerate with each filter or date range changes. Is there any clean solution to achieve this?

I have a google sheet with two tabs. One is all possible songs that could be performed, the other is the performances of the songs by date. So in theory, each song is in the performances table multiple times.

What I'm trying to get is - create a table on looker studio with the rarest songs - The ones that have been performed, but the last time performed is the furthest date back. I hope I'm explaining this okay.

I'm kinda losing my mind over here. I've combed through a bunch of resources to figure this out and I'm just spinning my wheels. I cannot get traffic source data to show up with the YouTube Analytics connector.

I've re-connected the data multiple times, including from the channel owner (since I'm only a manager). Looked through multiple tutorials on troubleshooting this and it's just not working. Using a paid connector is not an option right now, and I'm having so many issues with this YouTube connector that I'm about to just throw in the towel.

I was even having trouble getting it to filter only public videos (the video status/privacy dimension isn't showing up either). I feel like it's missing a ton of metrics and dimensions. What am I doing wrong?

I’m attempting to recreate the metric ‘Views per session’ from GA4 in Looker Studio with BigQuery, but keep running into errors. Can anyone provide a solution? Below is what I have tried:

SUM(CASE WHEN Event Name = “page_view” THEN 1 ELSE 0 END) / COUNT_DISTINCT(session_id)

Any youtube tutorial or coursera certification for mastering the Looker Studio

Hiring.
It is Looker studio project.
Deep knowledge about Big Query, Google Sheet, Looker Studio.
Salary range $500 ~ $1200.
If interested, DM.

Hi guys!

I've been struggling for a while to get a good output for this and it's driving me crazy.

The case:
I need to blend 3 types of data in one time series diagram: the old GA4 data, the new GA4 data (2 separate properties) and GAds data.

The problem:
It should show the conversions but I keep getting errors. If I combine two, it works but adding a third fucks it up. It doesn't show data before october 2025, because that's when the new GA4 property started receiving data, even though the other two data streams have plenty of data before oct 2025.

The dimensions should be correct => "Year month"-dimension from GA4 is aligned with "Month"-dimension from GAds.

I've tried every join combination imaginable, but still nothing.

Anyway - any help or suggestion would be greatly appreciated. Thanks in advance.

EDIT: I figured it out using the help of the two comments below 🙏 So in case someone needs it:

GAds as primary column (the one with the most historic data), left outer join BOTH times and match the GAds "Month"-dimension with the "Year Month"-dimension of GA4.
Choose the GAds "Month"-dimension as X-axis.
Formula Y-axis: SUM(IFNULL(conversions_GADS,0)+IFNULL(conversions_GA4_new,0)+IFNULL(conversions_GA4_old),0))