BookmarkSubscribe
Choose Language Hide Translation Bar

Re: Calculating average of zonal data in contour map

Don't know why it didn't take all my feedback.

Anyway, I went on the contour map, and used Customize and added a script and then entered the following:

0 Kudos
ms
Super User ms
Super User

Re: Calculating average of zonal data in contour map

Well, that formula was just an conceptual example. To get it in the data table you can manually add a new nominal column "Zone" and chose "Formula" under "Column Properties" enter your code (only the part to the right of the equal sign).

Remember that your "X" and "Y" must refer to other columns and if you paste your formula you must use :X and :Y, otherwise JMP may think they're parameters rather than columns. Alternatively you can use the formula editor but for this quite complicated formula it is easier to type it in a script window and copy and paste to the column formula.

You may also of course do it all by scripting, i-e create a column and use the "For each Row" command to fill the column with your zone labels.
0 Kudos

Re: Calculating average of zonal data in contour map

Ok that idea worked. Still a little tedious but I will try and automate it.

Thanks for your help and patience.
0 Kudos