AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
5.6K members online now
5.6K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Months Wrong Order

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello,


Data Studio is not displaying my months in their natural order - it is making it alphabetical.

 

Is there a way to correct this?

 

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Dave S
April 2017

Months Wrong Order

Participant ✭ ✭ ☆
# 3
Participant ✭ ✭ ☆

Wow I answered that whole thing as days of the week. Ok, with Sheets, months is easier than days. Just make sure that the month in your Sheet is in two digits (02 instead of 2), then when you import it, set it to "month" in the field type. This should then put them in the right order.

View solution in original post

Months Wrong Order

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

What's your data source? If you're pulling from Google Analytics, then there's a different dimension you can use (month of the year) that will show up in the right order. If you're pulling from Google Sheets, then make sure your day is represented as a number (I believe they count Sunday as 1 through Saturday as 7, but double check that that's accurate). Then, when you import it into DS, edit the field type so that it's a time-day dimension. This should have it show up as the day name and in the right order.

 

If it doesn't (I was having a problem with Sunday showing up as "7" when the rest had their proper names), you can always create a field in Sheets where you list them as (1) Monday, (2) Tuesday (or whatever order you want them to be in). Then when you list the dimension alphabetically, they'll be in the right order. It's not as pretty as the automated way, but if the automation doesn't work, this could be a workaround.

Marked as Best Answer.
Solution
Accepted by topic author Dave S
April 2017

Months Wrong Order

Participant ✭ ✭ ☆
# 3
Participant ✭ ✭ ☆

Wow I answered that whole thing as days of the week. Ok, with Sheets, months is easier than days. Just make sure that the month in your Sheet is in two digits (02 instead of 2), then when you import it, set it to "month" in the field type. This should then put them in the right order.

Months Wrong Order

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

That was perfect - thank you!

One new thing that's happening though is that I can't change the order from Descending vs. Ascending for the months - it starts with December and works backwards, no matter what I set the Descending vs. Ascending field to...Any thoughts?

Months Wrong Order

Participant ✭ ✭ ☆
# 5
Participant ✭ ✭ ☆

That's strange, I've never seen that! Try changing the sort to be the metric and then change it back to the month dimension and see if it'll let you ascending. If that doesn't work, try closing the report and then re-opening (sometimes that fixes things). If that doesn't work, I'm not sure where to go from there...you could try re-creating it? Sometimes when re-doing the visualization the thing that wasn't working starts working on the new try.

Months Wrong Order

Follower ✭ ☆ ☆
# 6
Follower ✭ ☆ ☆

Hi is there a way to populate month number as 01 if January, 02 if February ....12 if December. I wanted to make use of this field in other calculations. Please help me.

 

Thanks - Vamsi

 

Months Wrong Order

Participant ✭ ✭ ☆
# 7
Participant ✭ ✭ ☆

Is your data source GA or Sheets or something else?

Re: Months Wrong Order

Visitor ✭ ✭ ✭
# 8
Visitor ✭ ✭ ✭
Sheets Smiley Happy