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

How to sort "days of the week" dimension in chronological order? Data pulled from AdWords.

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello, 

 

as the title says: I am looking for a way to order the days of the week; specifically from alphabetical (friday - monday - saturday - sunday - thursday - tuesday - wednesday) to chronological. The data is pulled from AdWords.

 

I've read the suggestion that I should allot the individual days their appopriate number (like 0-6 or 1-7), but this generally seems to apply to Google Sheets. 

I also tried to change the type of the "day of the week"-dimension from "text" to "day of the week" in the "create new dimension"-tab, which didn't change anything (i.e. days continued to be shown in alphabetical order); and also from "text" to "numerical", which merged all days to a "null"-value.

 

Is there a way to transform the days into actual numbers, or just rename them if possible (like 01-monday, 02-tuesday etc.)?

 

Thanks in advance for your answers!

Highlighted

How to sort "days of the week" dimension in chronological order? Data pulled from AdWords.

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

No one got any insights?