How to group blended data by week or month in Looker Studio?

[MariaReynaFlore]

I can't group blend data by year or month in Looker Studio. When I tried to change day (original data type) to year, data remains at the date level, and the year gets repeated on every single line. Same will apply to line charts, bar charts.

@sam8 

[sam8]

Blending by dates can definitely get messy in Looker Studio, just as joining by dates can get messy in SQL.

What are you trying to achieve here? Maybe there's another way to get the results you want.

If you must blend on dates, I find that it tends to work better if you have a separate table (or just a simple Google Sheet) with the dates. Start your blend from there, then join both of other tables to the base table rather than to each other.

[Equipo_AG]

Hi Sam, hope you're doing well. I tried this in a blended table, but it didn't work well. I have two tables that I visualize using the date as the main dimension and when I want I can group the info by week, month, etc. But when I blend both tables and try to do this the info is grouped by day. Even if I try to change the format it only change the visual format but never groups the info. I tried with COALESCE and using another table with the dates like you explained. But nothings seems to work well.

Hope you read this and can spread some of your wisdom!

Thanks

[sam8]

Sure! I can share a basic example that worked well for me, and hopefully it'll help you get yours working. 

So, I made a little sample table with dates from December 2024, and then made a sample "feedback" table and "orders" table with some dates in that same month. You can see the blend and the data results in the following images:

As you mentioned, changing the granularity from day to month via the default options, like display format, doesn't work well. So, instead, I created a new calculated field that computes the month (using the formula `MONTH(date_field)`), and then I grouped on that. 

[Daniel_at_air]

I am having the same problem.