u/TinyMachine48

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!