Sorting data based on the day of the week

Question

Hi Alteryx Crew,

I'm pretty new to Aletryx and have what might be a simple problem to solve but I'm trying to order this data based on the Day_of_Week from "Monday" to "Sunday". to get the day of the week for each date I used the formula DateTimeformat([Submission_Date], "%A").  As mentioned it might be simple problem to solve but I'm just drawing a blank.

All help is much appreciated guys and gals.

Activity_IDSubmission_DateResponders_EmailRepeat_For_The_WeekDay_of_Week22110/09/2021 08:17una.Murphy@test.comRepeat my activity index for the remainder of the weekFriday32013/09/2021 16:30yiu.Rao@test.comRepeat my activity index for the remainder of the weekMonday31411/09/2021 16:34Mark.Alonso@test.comRepeat my activity index for the remainder of the weekSaturday186103/10/2021 22:06Kevin.Martins@test.comRepeat my activity index for the remainder of the weekSunday11209/09/2021 16:30Maria.Union@test.comRepeat my activity index for the remainder of the weekThursday44114/09/2021 16:30Tony.Barker@test.comRepeat my activity index for the remainder of the weekTuesday1108/09/2021 16:37Joe.Bloggs@test.comRepeat my activity index for the remainder of the weekWednesday

gautiergodard · Accepted Answer

@Deano478one way to do this would be to create a formula to assign a number to each day of the week and then sort based on that newly created field.

example:

if dayofweek = Monday then 1

elseif dayofweek = Tuesday then 2

elseif dayofweek = Wednesday then 3

etc…

hope this helps !!

Felipe_Ribeir0 · Accepted Answer

Hi @Deano478

You can use the DateTimeFormat([Submission_Date], '%u') formula to transform the date into a week day number between 1 and 7 and order by it.

%uDay of week as a decimal, 1 to 7, with Monday as 1

Sarreddy · Accepted Answer

@Deano478