Sorting X Axis by Day of Week

Question & Answer
2

Hi @Tanisha_Shetty -

If you have the actual dates you can do this.

  1. Create a calculated field for the sorting.
    c_week_day
    extract('WD',dt)

  2. Go to “sort options” in your x-axis dimension and sort by c_week_day (max/min) ascending.

    image
    image1150×700 54.7 KB

If for some reason you don’t have actual dates but strings with the day of the week. You can do something like this but in reverse, then use the calculated field with step 2.

ifelse(
extract('WD',dt)=1,'Sunday',
extract('WD',dt)=2,'Monday',
extract('WD',dt)=3,'Tuesday',
extract('WD',dt)=4,'Wednesday',
extract('WD',dt)=5,'Thursday',
extract('WD',dt)=6,'Friday',
extract('WD',dt)=7,'Saturday',null)