r/LookerStudio

Weekly Aggregation Question

Hi! I have a google sheet that I connect to looker studio to create tables.

Google sheet has metrics broken down by date, with a lookup column to a week number, as determined by my company.

In looker studio I am attempting to visualize the metrics by week, but looker studio is adding a row for each day within the week without summing the metrics for that week. Any ideas on how to fix this?

I want one row per week, not 7!

u/TinyMachine48 — 9 days ago

▲ 8 r/LookerStudio+1 crossposts

Has anybody ever updated dozens/hundreds of reports in bulk

We're an agency that uses Data Studio to provide reports to our clients. We started with one "template" report which we copy every time we onboard a new client. The problem is that we now need to make some updates to a certain chart and data source as well as some static text for all of our reports.

I was hoping there'd be some kind of API to make bulk changes but there doesn't appear to be. We're looking at having to do them all manually or trying to be clever and hacking some sort of officially unsupported automated solution together. Anybody been in the same boat and found a solution?

reddit.com

u/dbizzler — 14 days ago