79505024

Date: 2025-03-12 22:50:22
Score: 1.5
Natty:
Report link

Similar to the answers above, you need a heatmap pivot table — but, to get the days of the week sorted in the correct order, you do not use the Day of Week dimension. ("Day of Week" is a text-formatted dimension and therefore will always sort alphabetically.)

What you want to use as your column is a formatted Date dimension, which is formatted as datetime. (For Google Ads, use "Day".) Select "Date" as your base dimension, then go into the dimension details and change the following:

Data Type: Date & Time > Day of Week
Display Format: Day Name (or "Day Name abbreviated" for Sun, Mon, Tues, etc.)

Then sort your chart's columns by Date > Ascending.

This should give you the days of the week in chronological order, starting with Sunday.

Screenshot highlighting where to edit the dimension details: The icon to the left of the dimension name Screenshot highlighting where the the Data Type and Display Format for the Date dimension have been changed Screenshot showing the final pivot table with the days of the week sorted in chronological order

Reasons:
  • Probably link only (1):
  • Long answer (-0.5):
  • No code block (0.5):
  • Low reputation (0.5):
Posted by: Boxbot