Actually, I want to count (unique count) of an string field (for example unique count of customer or unique count of Id ) per day of week during a specific time.
And when I am using this field as "Term aggregation" for X-Axis ( because I want to visualize how many customers will be in different week days in order to compare them with each other) , and set "Order By : Unique count of customer" and also order same as below (7 days of week):
The result will be :
Logically this aggregation shows the first 7 days with highest amount of customer and as you can see I have more than one Wednesday (I understand completely the result).
Finally I want to have 7 bars each belongs to each day of week ( Sunday , Monday ,...) and the height of bars shows sum of customers in each week day during a specific period of time. Then I think I need to consider Start_Date as string in order to solve my problem ( I don't have any vision about any other possibilities)
Thank you so much for your response,