Hello all, I am using Charts for my application, specifically Column Chart, and I am wondering and looking for answer of x-axis label sorting.
In my logic, I append each row of data ordered by month, so the data label showing should be in order as well (January, Feb, Mar, ..., December), which is what I am looking to achieve, so regardless of empty data or not, each year should show month label in sequential order.
My logic, GetMonts is sorted by month order, and GetCountdata3 is filtered by each order
Now I have data from several years, but on each year x-axis label is showing in random order, see picture for example.
Data from 2021 (month starts in August)
Data from 2023 (month starts in May)
Data from 1900 (month starts in February)
I have wondered through various resources but none of them worked so far, the only option remaining is overwriting HighchartsJSON or XAxisJSON variable which so far I am unable to do. From what i read, Outsystems will inherenty assign format for these charts, so without overwriting them using HighchartsJS, it will remain that way. If anyone has similar experience, please share them here on what is the shortest path to achieve sorting x-axis.
Thanks.