Choose Language Hide Translation Bar
Highlighted
ron_horne
Super User

Re: summary table sorted in the wrong order if there are value labels

Hi ChungWei,

I don't think so. JMP has the perfect flexibility to offer value labels on top of the values themselves which is complementary and should not be a substitute. this allows for multidimensionality.

table summary is the only case i came across so far in the program that has this behavior of guessing that value labels should be recoded on the fly.

please let me know if you are aware of any other platforms/processes that do that.

in addition i do not find it correct to sort by the labels rather than the values. consider the following: using a variable that takes values from 1-5 where the user has labeled 1 as "Low" and 5 as "High". in this case the summary by that variable will come in an unintuitive order. (i.e. High, Low, 2, 3, 4 instead of low, 2, 3, 4, High). and that is in a case of trivial labeling. if labeling is more "sophisticated" then the difference between intuition and results can increase even further.

Thanks!

0 Kudos
chungwei
Staff

Re: summary table sorted in the wrong order if there are value labels

The case that you mentioned,  1 labeled as low, 5 as high, comes out as you expected, low is sorted first, high is sorted last in summary.

Other platforms that do that are tabulate and chart.

0 Kudos
chungwei
Staff

Re: summary table sorted in the wrong order if there are value labels

Grouping the data by labels gives the flexibility of aggregating different values into a group without actually changing your data.

It also removes the ambiguity, what to do when 2 values are mapped to the same label.

0 Kudos