Hello, I am using helical insight EE 5.0 RC1 GIT 686. I have created month number wise chart, but somehow sorting does not seem to work. Please help
As we saw in the call month number is also having NULL, hence it is getting converted fro number to string and sorting is happening on string which is throwing the chart off balance. You can apply filter and use condition is not null. This will remove the null values and then all numbers will be behave correctly.
If something similar happen again, you should add “is not null” filter on that column and then apply sorting.