ui: table view sorts lexicographically when it should sort numerically

[mark-rushakoff]

Here is a screenshot of my raw data. Note that the rightmost numeric column is of type long.

When rendered as a table, the column appears to be sorted by the string representation of the numbers rather than by the numeric values:

Running with build 11bfc0b.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[mark-rushakoff]

I assume based on #14217 that this issue is still outstanding.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[lukevmorris]

Bumping this

Flux table result:

#group,false,false,false
#datatype,string,long,long
#default,_result,,
,result,table,bytes
,,0,132800339
,,0,39665590
,,0,8505848
,,0,6301539
,,0,3709228
,,0,1491019
,,0,1301411
,,0,1279743
,,0,862723
,,0,757414
,,0,328315
,,0,25423
,,0,22234
,,0,22030

When I view the Raw Data, I see the flux table as it appears above.

When I switch to a Table graph type, I see the following:

These appear to be sorted alphabetically instead of numerically.

[lukevmorris]

Related: #15980

[rawkode]

Just bumped into this problem too. Even though my Flux has sort(), the table view does it's own sorting with string comparison rather than numeric.

[asalem1]

This should be resolved in #16235