I have a string field in my data set "Week_day" which contains Monday , Tuesday ,.... . I want to create a barchart to show average of sales in each day during a period. when I am using bar chart and average aggregation , in the phase of X.Axis definition I define term aggregation and select "Week_day" and the order is based on "average of sales" . In this way, the week days will be sort based on highest average but I am looking for a way to have a sort of week days in X.Axis looks like ( Monday Tuesday Wednesday ...) and each bar shows the average of sales belongs that day.
P.S : I also have timestamp field in my dataset.