r/GoogleDataStudio

Anyone else seeing errors ever since the rebrand back to Datastudio?

Hello,

I'd like to know if anyone knows of a standard solution, hack or community visualization that may be able to show a dimension (instead of a metric) in a pivot table. Intended result below:

Employee	03/01/2026	03/02/2026	03/03/2026
Jane Doe	Office	Absent	Office
John Smith	Office	Office	Vacation

The columns must be a date (that's dynamic to filter the date range) therefore the columns may change depending on the data range selected.

Thank you!

I am brand new to Looker. Like brand brand new. I am trying to create a metrics dashboard for the company I work for, to show individual, team, and business level metrics for our customer experience team.

I imported my Google Sheet, but get the feeling my sheet is too "busy" for Looker. I ran the sheet through AI and it suggested changes to headers, making separate tabs for weekly, monthly, and yearly numbers, etc.

Does anyone have anywhere to recommend to get some of the basics of Looker down? YouTube channel? Google Skills?

I really want to tackle this myself, and would love to learn better spreadsheet management, so it becomes easy to use Looker. Any help you can offer would be amazing!

I can't imagine I'm the only one, and I feel it stems from the change in names (though it shouldn't).

Whenever I try to export a report built on top of GA4 with a data control field to select a desired account, the export yields the default account associated with the initial setup, and ignores the data control entirely, which is set to report level. This has been working for as long as I can remember. Only over the past week has it been acting up.

I've tried deleting the data control and adding it back, but I have had no success with that either.

Also, maybe it's not clear, but when viewing the report, the data is accurately displaying. This only pertains to exporting.

Has anyone encountered this before? Any recommendations?

Fala, pessoal!

Atualmente sou analista de BI e atuo no processo de ponta a ponta (reunião de requisitos, mapeamento, ETL, criação de dashboards e apresentação). Trabalho em uma terceirizada e embora hoje eu faça a extração das bases de forma manual, meu foco forte é na automação do ETL e na visualização dos dados.

Fui chamado recentemente para uma entrevista em uma consultoria que faz exatamente o que eu estava pensando em criar como projeto paralelo, o que me acendeu um alerta: por que não fazer isso por conta própria?

A Ideia:

Criar um processo simples para atender pequenos e médios clientes. A ideia é que o cliente me envie a base, eu faça a modelagem ali mesmo e suba um dashboard automatizado no Looker.

-Meu nicho inicial: Empresas de logística, e-commerce ou gestores de tráfego, justamente para aproveitar a facilidade de integração nativa do Looker com ferramentas como Google Analytics e Google Ads.

Não pretendo viver disso agora. O objetivo é criar um projeto estruturado para gerar uma renda extra pegando demandas aos finais de semana, sem gerar pressão no meu trabalho principal de segunda a sexta.

Alguém aqui tem experiência com esse modelo de freela focado em arquiteturas mais simples (Sheets + Looker)? Vale a pena o esforço de prospecção para rodar algo assim como um serviço de entrada para esses nichos?

Abraços e obrigado pela ajuda!

https://preview.redd.it/33yg48yjosug1.jpg?width=6250&format=pjpg&auto=webp&s=ca70e8826854bebd8f468479bd00339c35ebc672

Hi, does anyone else have problems with connecting sistrix to any dashboard? And any solutions? Re-connecting wont work...

https://preview.redd.it/lljsy797wovg1.png?width=1183&format=png&auto=webp&s=bd3151890e5ed6877ea3ca55a0eda935192f34f0

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.

Hello team,

Last week, we encountered a very unusual issue: every COALESCE applied between fields from tables within a blend is being flagged as an invalid formula.

Sample blend:

https://preview.redd.it/romq5yhbdktg1.png?width=775&format=png&auto=webp&s=6f3a416169cd4501efe824df61ac306de2c127cd

Error:

https://preview.redd.it/ddwk10medktg1.png?width=306&format=png&auto=webp&s=91671de3cc00d1dabd54e898cf390b0a7dd510cf

Additionally, although the COALESCE function does return a value, all results are coming through as unformatted timestamps.

https://preview.redd.it/5kdgg01jdktg1.png?width=348&format=png&auto=webp&s=98d67723b1eef2cf96baf15d1488ffb7851d9680

It’s worth noting that this function was working correctly last week. I’m not sure if this behavior is related to a recent update.

Thank you in advance.

I'm using GA4 as my data source in Looker Studio and I have a table grouped by Campaign. I'm trying to add a column that shows the percentage of sessions that scrolled 50% of the page.

We track scroll depth via a custom GTM event that fires at 25%, 50%, 75% and 90% scroll depth. This event is pushed to GA4 with a `Scroll percentage` parameter containing the value (25, 50, 75 or 90). So in GA4/Looker Studio, `Scroll percentage` is an event parameter dimension.

I already have two scorecards that work fine:

- One showing total sessions

- One showing sessions with a chart-level filter on `Scroll percentage = 50`

But I can't get this to work as a calculated column in a table grouped by Campaign.

I already tried to create a calculated field with formula:

SUM(CASE WHEN Scroll percentage = "50" THEN 1 ELSE 0 END) / Sessions

But there it seems to always return 1 and then divide by sessions. It is not summing all sessions where Scroll percentage = 50.

​

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 🙂

https://preview.redd.it/p1knljbhm5qg1.png?width=966&format=png&auto=webp&s=3c5fee97409a2c4ff92c6533ce03cac9599cb98f

Line chart
GSC (Site) source.
Dimension is Date (date)
Date range Today -12 mointh to Today -1 month (mar 25 - Feb 26)
Has a calculcated dimension as the Breakdown
There is data for Feb 26 0 that's shown when date range is Last Month.

I'm sure I am doing something obviously wrong. Data for Feb 26 does not show in table form either.

https://preview.redd.it/izm0h2an26qg1.png?width=393&format=png&auto=webp&s=39f9c7e11669eb208216acf16091710f07813f35

https://preview.redd.it/mb08mhns26qg1.png?width=310&format=png&auto=webp&s=112598e074e34f844a350d7db18fa3004bc3c0bf

I'm creating a table that shows specific conversion events by first user channel group, but when there's no events, the group doesn't show instead I want it to show with a '0'.

My table is set up with dimensions as 'First user channel group' and 'event name' + metrics as 'event count' then a filter for 'include event name equal to Event X' (the event I'm looking at).

In the style tab, I've selected Missing data = show 0, but this hasn't worked - any other ideas of how I can get the non converting channels to show?

i want a looker studio template gathering my paid campaigns cross different paid channels (its daily updates,amount spent,amount remained, Start date,end date....etc)

The Goal: I am trying to create a Year-over-Year (YoY) comparison in a Pivot Table. My goal is to show the monthly metric for two years side-by-side (2024 vs 2025) and add a column for the % Difference between them without using a calculated field.

Current Setup:

• Data Source: Google Sheets / CSV.
• Date Range Dimension: Set to my original date field (verified as a "Date" type with the calendar icon).
• Row Dimension: Original date field set to "Month" granularity.
• Column Dimension: Original date field set to "Year" granularity.
• Metric: A numeric field set to SUM.

The Problem:

1. Missing Menu: When I edit the Metric, the "Comparison calculation" dropdown (for Percent difference from corresponding period) is completely missing.
2. Missing Calendar Toggle: When I set the Default Date Range to "Custom" (tried Fixed, Advanced, and Today-based), the "Compare to" toggle at the bottom of the calendar popup does not appear at all.

Has anyone done this ?

I have WordPress website, installed site kit and have all the connections connected, but still the looker studio isn't showing data.