cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar

Col N Categories (💚)

☑ cool new feature
☑ could help many users!

☐ removes a „bug“

☐ nice to have

☐ nobody needs it

 

 

What inspired this wish list request? 

Strange that that function is not available in the formula editor (statistical) or JSL... Maybe next...

 

 

What is the improvement you would like to see? 

please synchronize the different platforms:
- Tables-Summary
- Tabulate
- Header Statistics

new column formula right click menu

- JSL aggregation function 
- and most important:
  Summary Statistics in Graph Builder

every aggregation function which is available via Header Statistics could/should be available via the other "platforms" as well.

 

At least: 

- add a JSL function Col N Unique.

- add a N unique entries to the new column formula  menu
- and in Graph builder, add  Statistics for Unique entries.
- and please (!),Add dense ranking to Ranking Tie and Col Rank functions 

missing entries should not be counted (see below)

for the JSL function: option to count /not count missing entries

 

Why is this idea important?

In Semiconductor Industry, users often ask:
- how many wafers (in this list of devices)

- how many batches (in this list of wafers)

 

other JMP users need the functionality for:
- how many countries (list of covid affected people)

- how many companies (list of employees)

- how many cities (list of people)


In JMP it's too complicated to get such answers!

Header Statistics is great - the other platforms should be optimized.

I guess, no user complained about "too many" options in the Header Statistics?
Nevertheless, to save newbies from crowded lists, the additional options could be hidden in a submenu - or behind a Shift-Click.


* )available via header statistics

nominal:

hogi_0-1728481855056.png


continuous:

hogi_2-1728481873431.png

 

hogi_1-1728481854895.png

 

more wishes submitted by  hogi_2-1702196401638.png

15 Comments
FairChipmunk471
Level I

Adding my voice to this request, esp. the N Categories Col () function. Also in semiconductors, and the constant back and forth to summary tables is tiresome... Thx!

hogi
Level XII

Col N Categories -> Col N Unique()
: )

 

Status changed to: Yes, Stay Tuned!

Changing the status of this as the main part of this wish has been implemented and will be available in JMP 19 - Col N Unique()

hogi
Level XII

hi Sarah, the new Col N Unique() is great, thanks!

Agree, the wish grew over time  - here is a new one for the remaining part:
Please synchronize Summary Statistics (Tables/Summary - Tabulate - Graph Builder Summary Statistics ... 
can we transfer the 17 Kudos to the new wish?  ; )

Status changed to: Delivered