Note: For certain values that have a natural ordering, such as days of the week, JMP automatically orders these in the appropriate way in reports. See the Using JMP book.
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.
The Value Ordering property is not assigned by the Covering Array or Taguchi Arrays platforms. The Covering Array platform assigns the Value Labels column property. See Value Labels.
Suppose that you want the values for a factor to appear in a different order in the Prediction Profiler. Consider an example of a wine tasting experiment, constructed using Custom Design. Wine is rated by five experts, each listed as a Rater in the Wine Data.jmp sample data table. Rater is a fixed blocking factor. Nine factors are studied. Rating is the response.
1.
|
2.
|
3.
|
Click Run.
|
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.
|
Click OK.
|
8.
|
9.
|
Click Reverse.
|
10.
|
Click OK.
|
11.
|
12.
|
Click Run.
|
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.
|
2.
|
Select the Brand column.
|
3.
|
Select Cols > Column Info.
|
4.
|
Under Column Properties, select Value Ordering.
|
6.
|
Click Move Up five times.
|
8.
|
Click Move Up seven times.
|
9.
|
Click OK.
|
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.
|
12.
|
13.
|
Click OK.
|
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.
|