Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
how are you creating your weekdays?
maybe use Sort by Expression
=Match(WEEKDAYFIELD,'Mon','Tue','Wed','Thu','Fri','Sat','Sun')
Could you post a sample/screenshot?
how are you creating your weekdays?
maybe use Sort by Expression
=Match(WEEKDAYFIELD,'Mon','Tue','Wed','Thu','Fri','Sat','Sun')
Try with Properties/Sort/Sort by expression
and as expression : index('mon thue wed thur frid sat sun', WeekDayField)
maybe this (sorts correct in my app)
only({1}weekday(yourdatefield))
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
Hi
find attached screenshot
use this expression:- Match(WeekDay,'Mon','Tue','Wed','Thu','Fri','Sat','Sun') in sort tab
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' ) )
thank you very much
I was having an issue sorting my date and the formula you provided worked!
Thanks,
Desmond