Hi, I am trying to setup a dashboard for my blogs. What I need is to see how many visitors came from each source for individual blog posts. For example, I want to see how many users came from youtube/instagram/facebook to Blog post 1. So what I am imagining is:

Column 1 = Page title
Column 2 = Number of visitors from youtube (session source = (youtube)
Column 3 = Number of visitors from youtube (session source = (Instagram)
Column 4 = Number of visitors from youtube (session source = (facebook)

Is there any way to do this? If yes, how?

Need to synchronise filter from different sites without using global filter.

I have data for a sports team and data for every single player and want to use them in one report.

There are a few topics which leads to multiple pages to make the view much better and easier to handle.

Anyway, since ChatGPT could help me, I was looking for a much powerful source.
That was the moment I logged into reddit for the first time of my life. Pls help. Pls.

Hi everyone. Really pulling my hair out over this one. Had previous identical setups that worked fine.

Trying to aggregate total ad spend on FB and Google Ads on 1 scorecard. Created blended days source for FB ads and GAds (both via supermetrics). Using formula amount spent + cost, aggregation is set to sum. Returns No Data. Using Date as the dimension for both with left outer join.

Interesting, using the bleed source on card. If I set amount spent as the metric it’ll show that. But setting it to cost returns No Data. Which seems to indicate a blending setup issue.

The individual data sources are working as I can display amount spent for each platform. Just won’t work when blending the two together. Also tried using looker’s native Gads connector. Same results.

I have older dashboards that used this exact setup which works fine. So I even tried clearing cache, rebooting, deleting and adding data sources, flipping the data source order. Nothing works.

Please help!

I am using Looker Studio and I have three nominal variables I need to "add" together. Each item has "strongly disagree, disagree, neutral, agree, strongly agree" response options. I want ONE variable that simply combines the frequencies from all three variables together- so it would be one variable with five possible response options, but now triple the sample size.

I tried CONCAT (and likely did it wrong), but it ended up stringing one participant's three responses into one big word: "disagreeagreeagree." If someone knows that I did here and can help with the syntax, my variables are "People 1" "People 2" and "People 3"

Any ideas? Thanks!

Edit to clarify: here is an example of what the data look like. I want to create one variable that combines all 3 variables and combines all likert options together. I only want to know HOW MANY likert options were listed (how many agree, how many disagree, etc.). So for this example, I need my NEW variable to graph that shows I have 1 strongly disagree, 3 disagree, 5 agree, 3 strongly agree

https://preview.redd.it/tdpxithd57ge1.png?width=590&format=png&auto=webp&s=85b07a722582ef7e3ce3aff4559551684f35afe3

Hello I want to display the following data in my Looker Studio Report:

My Data Source is from GA4.

I'm using session default channel group as the dimensions and for the metrics, I'm using a calculated field with the code below:

CASE
WHEN Date >= DATE(2024, 6, 25) AND Date <= DATE(2024, 7, 24) THEN Active users
ELSE 0
END

Unfortunately, I am getting the following error:

Sorry, calculated fields can't mix metrics (aggregated values) and dimensions (non-aggregated values). Please check the aggregation types of the fields used in this formula.

I've tried simplifying the code to better understand the issue with the following:

CASE 
WHEN Date = DATE(2024, 07, 07) THEN Sessions
ELSE 0
END

Unfortunately I'm still getting the same error message.

How can I achieve this? Thank you

Ok guys I refuse to think this is harder than it seems so being a newb it’s most likely me

I have a scorecard for the month that works great, I copied and set it up to default date range advanced and put it so it looks at last month. Here the thing

I need that date to be last month of whatever the date range control is set to, NOT to todays date

So if there is a way help a lady out I’d really appreciate it 😭 I’m certain there’s a way to create a calculated field for last months data. But every example is either broken, misspelled or user error and I can’t seem to plug it in.

Appreciate the help so much!

Is there a way to see how a dashboard on a past date (i.e. last week, last quarter? I know it connects directly to the data source but is there a way to see historical views

Hello,

I hope that a developer, social media manager or anyone from Google is actually on this subreddit - because we've been unable to rename sections for about 3-4 days now.....

We have tried switching accounts, incognito, cleared cookies and cache - even got a fresh Google account to see if it'll work.... it didn't....

There is a whole discussion about this topic on this post: Re: Unable to rename sections in looker studio rep... - Google Cloud Community

Also, if someone has other ideas on how to bypass this issue - I'm all ears :)

Hi r/GoogleDataStudio community! I am hoping you can help me please.

I have two Google Sheet data sources which I can not seem to get working together:

• 1 - Contains Data from 2024

• 2 - Contains Data from 2025

I need to combine these data sets so that when I filter by date, it pull data from the applicable sheet. Both contain the same column headings.

For example, I originally setup 2025 data without a blend - the output I want looks like this. When I blended the two, my result was this, which has broken the pie chart.

I tried blending my data at first by the "buyer" key which resulted in the above, then tried "date" as my key. Both broke the chart.

I also noticed that I had to select the dimensions from either of table 1 or 2 - that's not what I want. I want to see all "buyers" from both data sets. Eg, when I selected Table 2 as the dimension field, it returned the buyer names as Table 2 contained the 2025 data which is what I'm filtered to. These were removed when I selected Table 1 as the dimension field.

I've combined the revenue from both data sources using a calculated field, but I still need to see all buyers the date range selected in the filter.

Would anyone happen to know what I've done wrong here? Thank you in advance!

Hey! I've been trying to graph in Looker some customized events stored in GA4 but it's becoming difficult to accomplish this task. Basically, I'm creating customized metrics/dimensions and reconnecting the source of data in Looker to make it available when doing the chart. This is not working properly since it is not displaying the label of the parameter of the event I'm adding to the chart and sometimes it doesn't bring properly the data. Does any one know any way to make it work? I'm talking about "nombre" property that has inside the name of the product that was viewed

https://preview.redd.it/pu0u2tfxstfe1.png?width=774&format=png&auto=webp&s=2a2447bc3e68063a298ac4ec0cd1e9595c96d6a6

Hello,

Our Looker reports have gotten slower over time primarily due to the increasing volume of the data in the data sources.

I've made various adjustment to the data sources as well as the report in an attempt to speed it up, but am now looking for a more durable solution that is able to handle larger datasets.

I was wondering if it would have any effect to transfer all data from the current data source, which is a Google sheet, to tables in BigQuery.

Does anyone have any experience with this and can share the results you have gotten?

I have a line chart that is pulling in data that has a "week ending" field for each record.

I set the "data type" in the date field to different aggregation levels (Week, Month, Quarter, Year) and the chart still shows a point for each week (doesn't group by higher levels). The labels across the bottom of the chart change (see picture) but not the chart itself.

Week ending chart correctly shows a point for each week

Goin all the way up to Year it changes the labels below, but not the chart.

Chart setup

I'm stumped. What am I doing wrong?

Hi everyone,

I came across this awesome dashboard design in Looker Studio and noticed the side tabs for navigation (highlighted in red). It has sections like "Organic Overview," "Brand vs Generic," and others for easy switching between views.

Does anyone know how to create these kinds of side tabs or a similar navigation style in Looker Studio? Is it a built-in feature or achieved through custom visuals?

Any guidance or tutorials would be greatly appreciated!

Dashboard link - https://lookerstudio.google.com/u/0/reporting/f1837c75-6dd4-4355-9966-ca1785d14302/page/p_0yvfv3saed

https://preview.redd.it/8ii832pobife1.png?width=1321&format=png&auto=webp&s=fd7e0797179e7a11cfe62d6690adeee69354d8b0

Thanks in advance!

I have a Date column (in Date format) and a time column (in a 24hr text format). I need to merge the two so that I can calculate duration agains another field which is already in a combined DateTime format from the original data source (google sheet).

Can you help out? I’ve tried so many things including Parse_DateTime to format the time as a date&time but that gives me a default date of 1/1/1970

I have data of when students took any test in the system. I want to see how many new students took a test each month, meaning I count only the first time they took a test and not count any of their subsequent tests. I have the user ID field already set to count distinct, but I don't think it's doing it based on the first time it encounters that user ID by the test dates. How can I achieve this?

Hi, I've got a bit of a problem.

So I'm trying to get the Meta Ads data in a looker Studio dashboard for easier viewing via a csv-file. There should be 8 campaigns visible but only 2 are showing up in my dashboard.

Does anyone has an idea what the problem could be?

Thanks in advance

Hi everybody,

I am having some trouble making a pie chart in Looker Studio. I need to make the pie chart the percent of emails opened on desktop, mobile, tablet, and unknown platform. Is this possible?

I've made a bar chart without problems, and a table works totally fine, but I need a pie chart.

I am getting my data from MAPP, so I would stay away from reformatting the sheet unless it's easy every month I paste the data in.

I've attached a picture of my data. It's itemized by campaign.

https://preview.redd.it/8csbhx0o0oee1.png?width=569&format=png&auto=webp&s=1ecf9e7a596f5fed22c458f2c69f34af3afd8480

I have a blend that I thought was working up until I tried adding a new field to it. Now I'm realizing it may have been broken for a while unbeknownst to me so I'm trying to debug it at its most basic.

Without any filters applied to the blends, totals match the source tables and row counts are very close. Applying filters throws it all of, though. Row count sizeabley decreases depending on the filter and many rows that are present in the source tables are now missing. This makes the blend essentially useless.

What am I doing wrong??

https://preview.redd.it/7uzg3e81tkee1.png?width=1255&format=png&auto=webp&s=81325625272287de8b8b21d94eb2e5579d7e20a5

https://preview.redd.it/dc3xm9optkee1.png?width=1018&format=png&auto=webp&s=b733afa141c4ff8650b09292ff92bcc905d6c6af

I used to use GA connector a lot (not anymore, shifted from GA altogether). Recently, I needed to use Looker Studio again and found so many new connectors on the gallery. It just made me wonder have y'all explored and are there any fav/preferred ones?

Hi,

I'm in a bit of a pickle. For monetary reasons we have to cancel our subscription to supermetrics so we would like to save the data in our reports that work now.

We thought that extract data would help us here, so we would create new extract data connectora with the data that we are about to lose.

My question is, are we gonna keep that data when we cancel supermetrics next month?

Thank you!

Im trying to do something i thought was relatively simple.

I've got some data in sheets that is sorted by months. I want to have this data in lookerstudio, sorted the same way, with months. Anyone know the simple fix? I tried many things but nothing seems to work.

Has anyone used this for FB Ads?

Need help with a filter issue. I have a US filter on one page of report which is a page level filter (exclude A and B from page path and screen title = US), similarly we have 2 more pages with A and B for two countries. Now I was creating a single report with a drop down filter using a field where I’ve put this formula:

CASE

WHEN REGEXP_CONTAINS ( Page path and screen class, “A”) THEN UK

WHEN REGEXP_CONTAINS ( Page path and screen class, “B”) THEN EU

WHEN NOT REGEXP_CONTAINS ( Page path and screen class, “A|B”) THEN US

ELSE “Unknown”

END

Now, let’s say total session I’m getting is 15k When i select US, session value shows 18k which is more than total sessions including US, UK and EU. While the actual US from single page report are around 12k which is the correct number.

Can someone please help me debug it? Thanks!!!

Hello,

I’m looking for help in creating a calculated column I urgently need for a dashboard. I’m having a hard time getting the right percentage to show for it and realize that I need to be looking at it distinctly.

Basically I have two columns. One called match_lead_id and the other called lead_id.

The lead_id column represents all of the individual leads I have.

The match_lead_id column is a true/false that is basically saying, is there a match between two different data sets for the same lead_id.

I have currently set up a calculated field that looks like this: Count(case when (match_lead_id = true then 1 else null end) / count(lead_id)

However shortly after creating this I realized this is not giving me the correct percentage because it’s not looking at things in a distinct manor as the rest of my dashboard is. So I am looking for any brave souls that are able to help me set this calculated column up to correctly look at it from a distinct view.

The main issue I keep running into is that when a do a count_distinct for numerator I just get one since it’s looking at a distinct count of the word true. Any tips on how I can get around this??? Thank you world

https://preview.redd.it/8rv7vsqwdeee1.png?width=1311&format=png&auto=webp&s=23f623d5fbbe298fccd16a0833f70b1619ed9b1d

Hey guys,

I am currently trying to access a BigQuery project that I own using Looker Studio connector but this shows up. Any idea why?
I am on the free tier on BQ btw.

Hi everyone,
So I have successfully connected Fb Ads to Google Ads based on Date (Left Outer).

Now I would like to add the CRM Sheet in, as I want to calculate the cost for each guest.

This would be calculated by the Total Ad Spend(FB AD Spend + GA Spend/ Number of Guests(CRM Google Sheet).

Hence I need to join the 3 data sources. Unfortunately, the only join I have found that works is Cross Join, which is messing up my GA and FB data.

Please help!

Hi everyone,

I created a report template for our agency that we can use with all our clients. Everything is prepared: tables are filled with dimensions and metrics and some basic filters are in place. But when I try to remove all data sources to create an empty template that everyone can use, several sources keep appearing in the report even after I've deleted them (many, many times). They all say "there's issues with the connection" and no data will actually load, but they're still in there and I'm scared someone will accidentally make them reusable sources and mess up all the reports they're connected to.

This affects 4-5 out of 12 sources that appear random - one of two GA4 accounts, one of two Google Ads accounts, one of two GSC accounts, two separate supermetrics connectors. The sources are all embedded. I've made several attempts on separate days but it never works out. Does anyone know a way to do this or is it simply impossible?

Eu preciso calcular a média geral dos consultores em uma planilha, mas a média no Looker Studio está saindo errada. Já tentei de tudo, mas ainda não funciona. Eu já consigo calcular a média por consultor, mas não consigo obter a média geral a partir dessa soma.

O que eu preciso é mostrar apenas a média geral (mês/ano) no dashboard, sem exibir as médias individuais dos consultores. Os dados na planilha estão estruturados assim:

Média dos Pontos dos Consultores:
SUM(Pontos diários) / COUNT_DISTINCT(EXTRACT(DAY FROM Data))

Pontos Diários:

CASE  
  WHEN Realizado = '✔' THEN Nota final  
  ELSE 0  
END

Nota Final:

CASE  
  WHEN Realizado = '✔' THEN Peso  
  WHEN Realizado = 'Sim' THEN Peso  
  ELSE 0  
END

Essas fórmulas retornam a média por consultor, mas não retornam a média geral ao excluir os consultores individuais.

Alguém pode me ajudar a calcular a média geral para o mês inteiro, excluindo as médias individuais dos consultores?

Planilha

Dashboard consultores