How to sort "days of the week" dimension in chronological order? Data pulled from AdWords.[ Edited ]
1 month ago - last edited 1 month ago
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!