Value Ordering Column Property for Type shows the Value Ordering panel for the Type column in the Car Physical Data.jmp sample data table. Reports that involve the values of Type place these levels in the order Sporty, Small, Compact, Medium, and Large. Use the buttons to the right of the Value Ordering list to specify your desired ordering for the values.
Value Ordering Column Property for Type
1.
Select Help > Sample Data Library and open Design Experiment/Wine Data.jmp.
2.
Select Run Script from the Reduced Model red triangle menu.
3.
Click Run.
Profiler with Original Value Ordering
Notice that the values for De-Stem and Filtering appear in the order No followed by Yes. You want to reverse these, so that the Yes level appears first.
5.
In the data table, click the asterisk next to De-Stem in the columns panel and select Value Ordering.
6.
Click Reverse.
7.
8.
Click the asterisk next to Filtering in the columns panel and select Value Ordering.
9.
Click Reverse.
10.
11.
Again, click the red triangle next to Reduced Model and select Run Script.
12.
Click Run.
Profiler with New Value Ordering
The levels for De-Stem and Filtering now appear in the order Yes followed by No.
13.
Close the Wine Data.jmp sample data table without saving the changes.
Consider the Candy Bars.jmp sample data table. Of the 18 brands lists under Brand, Hershey and M&M/Mars have the largest numbers of types of candy as listed in the Name column. You want these two brands to appear first in reports.
1.
Select Help > Sample Data Library and open Candy Bars.jmp.
2.
Select the Brand column.
3.
Select Cols > Column Info.
6.
Click Move Up five times.
8.
Click Move Up seven times.
9.
An asterisk indicating the Value Ordering column property appears next to Brand in the columns panel. JMP now lists Hershey and M&M/Mars first in reports involving Brand.
10.
Select Analyze > Distribution.
11.
Select Calories and click Y, Columns.
12.
Select Brand and click By.
13.
14.
While holding down the Ctrl key, from the red triangle next to Calories select Display Options > Horizontal Layout.
15.
Close the Candy Bars.jmp sample data table without saving the changes.