This content has been marked as final. Show 3 replies
You would need to load your days of week with a prefix such as
1 - Monday
2 - Tuesday
3 - Wednesday
Sorting only supports alphabetical for the string field type, there's no custom sort you can do with the Chart portlet.
If you have the original dates you can use EXTRACT(date1, DAY_OF_WEEK ) to get the rank of the days within the week. Then sort by this column.
@Jerome...I have done that only but 1-Monday,2-tuesday looks bad..
Any ways to remove 1- or 2- from the display