Sorting X Axis by Day of Week

Hi All, Is there a way to sort the X- Axis by Day of Week (Monday - Sunday)? I want to disregard any aggregate (count/count distinct) over the values to decide the sort order.

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.

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)