What do you mean by “that didn’t really work for my data”. What is the “that” that didn’t work, and what do you mean by “didn’t really work”.
As for the ordinal issue, you’ll have to make sure the data are in the correct format (https://www.jmp.com/support/help/en/17.0/index.shtml#page/jmp/column-properties-in-jmp.shtml).
Therein it says:
To assign a column property to one or more columns
1.Select the column or columns to which you want to assign a property.
2.Do one of the following:
–Right-click the header area, select Column Properties, and select the property.
–Right-click the header area, select Column Info, and select the property from the Column Properties menu.
–Select Cols > Column Info and select the property from the Column Properties menu.
3.In the column property panel that appears, specify values and select options as appropriate.