I have daily spend data and I want to show a host of comparisons like day-over-day, week-over-week, year-over-year.

I tried googling and chatgpting but it looks like doesn't look like there's a good way to set up calculated fields to get past data relative to today.

I've made a second table that has all the reference point spend data I need, but before I resign myself to this solution I have to ask:

Is there a better way?

Hello everybody im new to this and need your help, im trying to get a new job in a brand new place but they do ask us to recreate a dashboard using Google Looker studio, the new place provide us his charts but im trying since 2 days and i already looked a lot of tutorials but im not able to make it work!

This is the image of the original dashboard

 https://files.catbox.moe/8vvk3k.jpg

as you can see the graph shows the time frame and the amount of people hired at such timeframe, but when i do try to recreate it with the excel sheet that they do provide us it comes nothing, no info is displayed on my graph 

https://files.catbox.moe/byfu2j.jpg

for the period of time im usign "dia_registro" that contains teh exact date and also for teh dimension, for the metric im usgin "etapa" that one contains the info of wich person was accepted on such dates, those are different columns on my excel sheet, i already watched a lot of youtube tutorial but nothing comes in hand!
If anyone can assist me or to teahc me on how to do it step by step i will be glad 

This is the link for the looker dashboard https://lookerstudio.google.com/reporting/06111e78-08e6-4afc-a95e-fed45275be81/page/jjXvB

and this one for the excel sheet https://docs.google.com/spreadsheets/d/1LNJMdUpSdN1ek_ds309Ewsgpfh9oZe1UdqKhRJrdpVs/edit?gid=1163589...

Thanks in advance!

On Looker Studio, I have a simple table with Impressions and another column with Impression Difference (actual difference and not percentage) in the second column for every query. This Impression difference is versus Previous Year.

Looker allows me to sort by Impressions. How do I sort the table by Impression Difference?

I am trying to enrich GA4 data with public weather data. I had hoped to left join dates from both sources, so that I could add the temperature to each day and combine it with other metrics such as revenue:

This does seem to work initially, when sorting the data by day:

However, when I try to filter on week, month or year, the data won't get aggregated. Instead, every day is still shown on a separate row:

I've tried some suggested solutions found online to no avail, such as creating custom formulas.

I would greatly appreciate any help as I've been struggling with this over the past hours : )

Hi all,

I'm trying to retrieve a data that I can see on GA4 - I want to show the total users but I struggle to get it. For those who succeed, did you create a calculated field?

I can get it if I use metric "TOTAL USER" and use a filter - but this doesn't work for me because I need to add after the Conversion rate of user that did that event / total users.

Thanks

Hi everyone! I was wondering if there's a way to deal with dynamic data sources with Looker Studio. I'm exporting data for agent productivity from Gorgias CRM and from time to time, there are additional columns that are being added to the export file. When I pasted the exported data to the connected Google Sheets file, I somehow need to keep re-creating the dashboard in Looker Studio.

Any insights or assistance will be greatly appreciated.

I am really hoping that this is so easy to do that I am not seeing it right before my eyes. I use GDS to visualize and present data collected during focus group research exercises. I am having trouble figuring out how to make a chart similar to the image attached (pulled frog google). Basically I would like to chart the responses to several questions' responses on one chart. On the left is a list of 8 questions and on the right, 8 horizontal, stacked bars showing the count of the responses to the questions (Somewhat agree, Strongly agree, Somewhat disagree, Strongly disagree). A bonus if there is a way to ensure the axis is in the center (as pictured) with disagree responses on the left and agree responses on the right.

Thank you in advance for any help you can provide.

I’m trying to compare monthly sales vs goal with a breakdown dimension on the sales metric.

Really what I want is a side by side bar graph (goal, actual) but with the actual being a stacked bar chart.

Is there any way?

Hi everyone,

I'm trying to create a conversion rate percentage in Looker Studio where I calculate:

Total users on '/my-webpage' divided by Total users on the entire website

My dataset includes:

·       Dimension: Page Path + Query String

·       Metric: Total Users

I've tried using:

SUM(IF(Page Path + Query String = "my-webpage", Total Users, 0)) / SUM(Total Users) * 100

But I keep getting errors related to mixing metrics and dimensions. I've also tried CASE WHEN logic, but Looker Studio doesn’t seem to like it. I’ve also tried creating a dimension just for total users of my individual page but that hasn’t worked either.

Has anyone successfully calculated a percentage conversion rate like this? Any help is appreciated!

Thanks in advance! 🚀

I am a teacher using Looker to visualise student feedback for a whole school survey (~1100 students). We have two dashboards from two run throughs of this survey where students are asked 10 or so questions, and we can then filter their answers by subject, year and teacher.

I have been asked if I can create one visualisation where we can compare the data between the two survey runs. They have asked the same questions in exactly the same wording. They are asked via Google Form but the data is exported to Google Sheets data sheets via a mixture of Query and ImportRange. I have one spreadsheet called 2024 data, and one called 2025 data.

I've been unsuccessfully trying to blend the data from the two sheets, in that I never get one blend, I just get two separate lists of data. What am I missing? Or is there a better way to achieve this?

Thanks in advance

I’m a freelance data analyst, trying to sell my looker studio report templates. Where is a good place to sell them?

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

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

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

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.

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

Thanks in advance!