This is part of a Google Sheet I want to use as a Data Source to Data Studio:
This is what the fields in the Data Source look like:
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:
From which I obtained this, which is not correctly ordered by "ISO Week of the Year":
What am I doing wrong here?
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.