Solved

Sorting chart on date is not working properly

  • 2 July 2024
  • 1 reply
  • 41 views

Userlevel 1
Badge +2

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.

 

Graph sorted alphabetically instead of numerically

 

Cube settings

 

icon

Best answer by Arie V 5 July 2024, 19:40

View original

1 reply

Userlevel 6
Badge +10

@Allard Lakerveld saw something similar in our internal TCP app, this seems to me like a bug. Could you please raise this as a bug in TCP so we’ll pick it up for a fix and you can follow the progress?

Reply