Data Studio - Grouping by Week

user_2009557 0
Viewed 4510

I have a simple Data Studio table consisting of two columns. The first column is the week (ISO Year Week) and the second column is the total registrations we've received for that week.

However, my Week column repeats 7 times (7 Rows) for each week as it's counting by day within that week. See below:

enter image description here

Is there any way to get this to group by the listed week? Below are my settings:

Dimension = Conversion Date set as "ISO Year Week" for the type. Metric = Equals the count of Conversion Date (Same Conversion Date field used for dimension)

Any help would be much appreciated.

google-data-studio
1 Answers

There might be an issue with the date format of the source. Without knowing the source (e.g. Google Analytics or Sheets) it’s hard to tell.

Blended Data

I recently had this issue with blended data. The response of a similar question helped me to find a way.

Basically you have to add a new custom field to the data source with the formula WEEK(date_field_link). Data studio will recognise this as a date in compatibility mode, but for me it still works. Then you can use this new date field as a join key to blend the data while grouping it in weeks.

Normal Data

If this problem appears in a regular non-blended dataset you might want to check if Data Studio correctly catches the date as a date. This help article from Google might be worth checking out: https://support.google.com/datastudio/answer/6401549?hl=en#zippy=%2Cin-this-article

user_74210050
Related