When adding the custom sort to the "Sorting" field, it has no effect.  Attached is a screenshot and below is the code created in beast mode....what am I missing?

---

@TylerC wrote:

@phillipgornicki,

I wanted to make sure the answer we discussed was also posted here in case anyone else had a similar question.

In order to sort by day of week you would have to create a beast mode filter that looks similar to this:


CASE
WHEN `column` = 'MONDAY' THEN 1
WHEN `column` = 'TUESDAY' THEN 2
WHEN `column` = 'WEDNESDAY' THEN 3
WHEN `column` = 'THURSDAY' THEN 4
WHEN `column` = 'FRIDAY' THEN 5
WHEN `column` = 'SATURDAY' THEN 6
WHEN `column` = 'SUNDAY' THEN 7
END


Also note that you may need to use the TRIM() function in case there are any extra white spaces. 

Thank you.

---

I have created a sort and applied as shown, however it seems to have no affect, am I missing something? Below is my code/validated in beast mode.

(CASE
When 'Month' ='January - 2016' THEN 1
When 'Month' ='February - 2016' THEN 2
When 'Month' ='March - 2016' THEN 3
When 'Month' ='April - 2016' THEN 4
When 'Month' ='May - 2016' THEN 5
When 'Month' ='June - 2016' THEN 6
When 'Month' ='July - 2016' THEN 7
When 'Month' ='August - 2016' THEN 8
When 'Month' ='September - 2016' THEN 9
When 'Month' ='October - 2016' THEN 10
When 'Month' ='November - 2016' THEN 11
When 'Month' ='December - 2016' THEN 12
When 'Month' ='January - 2017' THEN 13
When 'Month' ='February - 2017' THEN 14
When 'Month' ='March - 2017' THEN 15
When 'Month' ='April - 2017' THEN 16
When 'Month' ='May - 2017' THEN 17
When 'Month' ='June - 2017' THEN 18
When 'Month' ='July - 2017' THEN 19
When 'Month' ='August - 2017' THEN 20
When 'Month' ='September - 2017' THEN 21
END)