I am trying to sort a column which contains the days of the week(i.e. Monday,Tuesday,Wednesday)but in the order of their occurrence.I mean the same way as it comes in a normal week.but the sorting is done in an alphabetical order which is not desired.
Any quick suggestion would be highly helpful to me.
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.