Subscribe Bookmark RSS Feed

jsl: scripting/formulating column property (value ordering) by a variable

saitcopuroglu

Community Trekker

Joined:

Sep 29, 2014

Hi,

i have a data set which grows and changes each day. One column is Agency Codes (more than 230) and the other is Net Revenue.

A use tabulate for analysing and the AgencyCode must be in the order of descending total NetRevenue produced by AgencyCode (I use ColSum of NetRevenue by AgencyCode formula).

Using Value Ordering in Column Properties does not work hence the Total NetRevenue of each agency is changing dynamically.

The question is: How will JMP set the value ordering of AgencyCodes ascending automatically according to the rapid changing data of Total Net Revenue?

Many thanks in advance

1 REPLY
ron_horne

Super User

Joined:

Jun 23, 2011

hi,

if you make a data table from the tabulate, sorting is just one line of JSL away.

ron