I'm making a bar chart that graphs car accidents by the day of the week the accident occurred. The problem is that the bar chart automatically sorts alphabetically by category. I want to have the days of the week in order ( mon, tue, wed, thurs etc.) not alphabetically (fri, mon, sat, sun, thurs, tues, wed). Is there a way to do this?
Note I tried using a numeric field which worked to get the days in the correct order, but then the axis labels were 0, 1, 2 etc. which is not what I'm after (See below). I couldn't find anyway to alter the labels. I tried using a coded value domain, ( 0 = Monday, 1 = Tuesday etc.) but the chart resorted back to alphabetical order. I also tried using a date field where I coerced all the dates into one week but the labels were again not satisfactory (1/5/2015 for Monday) and I couldn't find a way to format the date labels to show day of week.