Hi,
I have a chart that shows the capacity per day. The x-axis shows the dates. However, the sorting of the x-axis on dates is not working properly since it sorts alphabetically instead of numerically. E.g. 10 - 11 - 1, …, 20, 21, 2, … 3,30,31… instead of 1,2,3, etc.
The year, month and day in the cube are base on 1 column: date_day_only.
I think I can create a workaround here by adding the day in the view like 01,02,03 etc. but I think I am missing something here in the settings.
