Custom Sorting

Hi Everyone,

I followed the steps outlined here: https://dojo.domo.com/t5/iSolveditwithDomo/How-do-I-Create-a-Custom-Sort/m-p/45500#M13 but cannot get my custom sorting to work. 

Chart: Heatmap

Data: Google Ads Data, broken out by date and hour.

I attempted to do custom sorting for Day of Week (using a date transform) and Dayparts (custom grouing based off hours of day)

Dayparts - The hours in the data is represented 0 - 23 (Military time). Since I'm using a heatmap, it would look unwieldy to have that many rows of data. this is the beast mode I used to group:

(CASE

When `Hour Of Day` in ('6', '7', '8', '9') then 'Morning 6-9AM'
When `Hour Of Day` in ('10', '11', '12', '13', '14', '15', '16') then 'Daytime 10-4PM'
When `Hour Of Day` in ('17', '18', '19') then 'Early Fringe 5-7PM'
When `Hour Of Day` in ('20', '21', '22') then 'Prime 8-10PM'
When `Hour Of Day` in ('23', '0') then 'Late Fringe 11-12AM'
When `Hour Of Day` in ('1', '2', '3', '4', '5') then 'Overnight 1-5AM'

end

)

to do a custom sort, I used this beast mode:

CASE

when 'Dayparts' = 'Overnight 1-5AM' then 1
when 'Dayparts' = 'Morning 6-9AM' then 2
when 'Dayparts' = 'Daytime 10-4PM' then 3
when 'Dayparts' = 'Early Fringe 5-7PM' then 4
when 'Dayparts' = 'Prime 8-10PM' then 5
when 'Dayparts' = 'Late Fringe 11-12AM' then 6

end

I then take this beast mode for the sort and drag it into the sorting field. I make sure there is no aggregation and do ascending order. The result is that it's out of order (See my attached screenshot). 

Now onto Day of The Week

Day of Week. This is the beast Mode I used to return a day of week name:

(CASE

when dayofweek(`Date`) = 1 then 'Sunday'
when dayofweek(`Date`) = 2 then 'Monday'
when dayofweek(`Date`) = 3 then 'Tuesday'
when dayofweek(`Date`) = 4 then 'Wednesday'
when dayofweek(`Date`) = 5 then 'Thursday'
when dayofweek(`Date`) = 6 then 'Friday'
when dayofweek(`Date`) = 7 then 'Saturday'
end)

this is the beast mode I used to do the custom sort

CASE

When 'Day of Week Name' = 'Monday' then 1
When 'Day of Week Name' = 'Tuesday' then 2
When 'Day of Week Name' = 'Wednesday' then 3
When 'Day of Week Name' = 'Thursday' then 4
When 'Day of Week Name' = 'Friday' then 5
When 'Day of Week Name' = 'Saturday' then 6
When 'Day of Week Name' = 'Sunday' then 7

end

Similar to the Dayparts sort beast mode, everything is returned out of order. 

What am I doing wrong? The video I linked makes sense...maybe it's the fact that I am doing another step before the custom order that's throwing it off? Thanks!