Sorting of integer values on x-axis

[thisiszeev]

The data I am analyzing has 25 floats per data field, and their labels are 1-25.

I needed the line graph to build showing the floats from 1-25 so I can see the change.

The problem is the app sorted the labels as 1, 10, 11 etc.

I have rewritten my code to create the CSV file with a lead zero on the single digit integers, but I can see how for some instances this quirk could be a problem for others.

It would be nice to have the data labels sort as 1, 2, 3 etc by default.

[Rello]

Hi @thisiszeev
thank you for this valid commend. let me have a look. It makes sense...

[Rello]

Natural sort needs to be implemented in the initial data processing in javascript, as it is not easily available within the various DB backends.

Natural sorting needs to be selectable with a report or column parameter (drilldown dialog) => to be evaluated

            OCA.Analytics.currentReportData.data.sort((a, b) => {
                let result = a[0].localeCompare(b[0], undefined, { numeric: true });
                if (result === 0) {
                    return a[1].localeCompare(b[1], undefined, { numeric: true });
                }
                return result;
            });