Google Data Studio Aggregation with Sum - why doesn't it sort?

0
votes

This is part of a Google Sheet I want to use as a Data Source to Data Studio:

enter image description here

This is what the fields in the Data Source look like:

enter image description here

I want to present a bar chart with the metric "Mailchimp Subscribers" and with dimension "ISO Week of the Year", grouping by the latter and aggregating the former using Sum.

To try it out, I've opened the Data Explorer and grouped according to those specifications:

enter image description here

From which I obtained this, which is not correctly ordered by "ISO Week of the Year":

enter image description here

What am I doing wrong here?

1
google-sheetsgoogle-data-studio
I didn't use google sheets or data-studio. However, I see that you are sorting according to the sum of ISO Week of the Year. I think that sum aggregation is not correct in sorting option. - serdar
@serdar you're absolutely right - the mistake was there. Switching the aggregation in the sort from SUM to AVG did the trick. Thanks! - Filipe
Your welcome... - serdar

1 Answers

0
votes

I didn't use google sheets or data-studio. However, I see that you are sorting according to the sum of ISO Week of the Year. I think that sum option in sorting may not be correct.