Sorting week days

[Anonymous]

I have created a listbox with the weekdays. However they are lined in the wrong order. How can I correct this? I tried the sort by expresion option but couldn't succeed to sort them in the correct order. Thanks

[tresesco]

Could you post a sample/screenshot?

[vinieme12 · Accepted solution]

how are you creating your weekdays?

maybe use Sort by Expression

     =Match(WEEKDAYFIELD,'Mon','Tue','Wed','Thu','Fri','Sat','Sun')

[sergio0592]

Try with Properties/Sort/Sort by expression

and as expression : index('mon  thue  wed  thur   frid  sat  sun', WeekDayField)

[Anonymous]

maybe this (sorts correct in my app)

only({1}weekday(yourdatefield))

[its_anandrjs]

Better if you add one inline table in your data model and connect the Weekdays field with your Weekdays field in data model this will effective worked here.

WeeDaysSort:

Load * Inline

[

WeekDays,SortOrder

Mon,1

Tue,2

Wed,3

Thu,4

Fri,5

Sat,6

Sun,7

];

Regards

Anand

[shraddha_23]

Hi

find attached screenshot

use this expression:- Match(WeekDay,'Mon','Tue','Wed','Thu','Fri','Sat','Sun') in sort tab

[its_anandrjs]

If you required this in the front end UI then better you can do this way on your chart sort properties.

Ex:-

=ONLY( Match( YourWeekDayFieldname,'Mon','Tue','Wed','Thu','Fri','Sat','Sun' ) )

[Anonymous]

thank you very much

[dezmundw15]

I was having an issue sorting my date and the formula you provided worked!

Thanks,

Desmond