I have a field that is Day of the Week. The problem is that there's no option in the sort function when creating a table or a graph to manually order the order in which they display. So they just display in whatever order, as opposed to Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday.
I can't see the .qvw file because i'm using the personal edition. Can you give me the expression to use to sort on the script side, so that I can paste it in the expression field in the sort panel for the chart properties?
The table version is not sorting my days of week, it's just adding an extra column that I don't want for value. That would make it difficult to create charts, because I would have to include the value as a dimension to be sorted. I want that same effect, but I want the value of the day to stay forever hidden.