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

Col N Categories - and all the others ...

☑ 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

9 Comments
Status changed to: Acknowledged

Hi @hogi, thank you for taking the time to submit this idea and provide examples! We will review your request and keep you updated on its status. 

hogi
Level XII

- comment added to the main wish

hogi
Level XII

similar discussions in the community:

Add Counter for Unique Cases in Groups 

count unique 

Custom Function - how to reference the column 

Column reference in custom function 

count(distinct val) 
Formula for Number of Unique Categories in Column 

How Do I create a Column formula for N Categories? 

It's OK that users have to create their own workarounds for everyday tasks which are not yet available via standard function.
The danger: there are very slow workarounds out there. Then it's quite likely that new users will just copy them... and later complain about the poor performance of "JMP".

 

Much better:

If many users need a feature, just implement it directly in JMP/JSL.
Then the experts can find the fastest approach and provide it for all users.

hogi
Level XII

@hogi wrote:

missing entries should not be counted (see below)


maybe: please add an option to specify if Null/Missing/Empty is included in the counting or not.
Add function which can be universally used to check if object/variable is empty/missing 

without this option,
please: 
DON't COUNT MISSING ENTRIES

... then one can create one or the other mode via a transform column.

trish_roth
Level III

Concur, an N categories formula or count distinct function is very much needed. Often count how many distinct values are in a given By group.

How many distinct instruments used by month by account.  In SQL use count distinct function frequently. Need similar in JMP so as table updated, distinct count updates. Ability to use with multiple By variables as well.  

hogi
Level XII
hogi
Level XII

@Sarah-Sylvestre 
I moved a comment from Add normalization and robust statistical functions (and matrix functions)  to the main post of this wish
... to make it more general.


Could you please update the Wish in the internal tracking system.

hogi
Level XII

maybe : add Ppk, Cpk?
... to header statistics : )

Add custom formula and columns to Tabulate window by @Jackie_ 

hogi
Level XII

Great that the wish lives so long - enough time to add derivatives:

 in JSL, please also add a FAST *)  Unique entries (:col, groupby), Unique entries (List) , Unique entries (Matrix),


edit:

there exists a separate wish for this part:
Provide fast way to get unique values from JMP objects (column, lists), possibly similar to Python's... 
thanks @jthi .