[SOLVED] Column Sorting (ascending, descending)

victoriastuart
victoriastuart New Altair Community Member
edited November 5 in Community Q&A
I'm a new RM user ...

When sorting columns in the Results Perspective, the column sort is not 'intuitive' - i.e., not strictly ascending or descending if there are positive and negative numbers.  For example,

Attribute   PC1
potass 0.107
rating 0.075
fiber 0.005
fat 0.000
sodium -0.983
vitamins -0.101
sugars -0.006
weight -0.001
cups -0.000

IMHO, it would be much better if these data were sorted as in regular spreadsheets, e.g.

Attribute   PC1
potass 0.107
rating 0.075
fiber 0.005
fat 0.000
cups -0.000
weight -0.001
sugars -0.006
vitamins -0.101
sodium -0.983

... that way, I (we) could sort a column and quickly glance at the top and bottom of that column to see the max/min values -- which would be especially helpful for much longer columns, where [per the RM default (?) / the example shown above] the minimum value would be 'buried' way up in the table.

Is this possible, or could it be implemented (RM build)?  Thanks ...
Tagged:

Answers

  • fras
    fras New Altair Community Member
    Hi,

    if you use operator "Sort" before piping to result perspective you can fine tune sorting as
    you like it.

    -Frank
  • victoriastuart
    victoriastuart New Altair Community Member
    Good to know; thank you - appreciated!