Col N Categories (:green_heart:)
☑ 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 version.
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:
continuous:
more wishes submitted by 
Automation and ScriptingData Blending and CleanupData Exploration and VisualizationRe: new JSL function: Col N Categoriessimilar 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.
Re: new JSL function: Col N Categories- comment added to the main wish
Re: new JSL function: Col N Categories - Status changed to: AcknowledgedHi @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.
Re: new JSL function: Col N Categories
@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.
Re: Col N CategoriesConcur, 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.
Re: Col N Categories related wishes by @jthi
Add dense ranking to Ranking Tie and Col Rank functions (October 2024: 9 Kudos)
Add normalization and robust statistical functions (and matrix functions) (October 2024: 6 Kudos)
Re: Col N Categories - and all the others ...@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.
Re: Col N Categories - and all the others ...maybe : add Ppk, Cpk?
... to header statistics : )
Add custom formula and columns to Tabulate window by @Jackie_
Re: Col N Categories - and all the others ...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 Set
thanks @jthi .
Re: Col N Categories - and all the others ...Instead of adding more wheels to the car, one could add a universal warp mode:
Transform Columns - as comfortable as Summary Statistics?
Thank you, it takes JMP to a whole new level - and instantaneously fixes most of my headache with aggregated GraphBuilder plots.
Re: Col N Categories - and all the others ...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!
Re: Col N Categories - and all the others ...Col N Categories -> Col N Unique()
: )
Re: Col N Categories - and all the others ... - 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()
Re: Col N Categories - and all the others ...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 - Distribution - Header Statistics)
can we transfer the 17 Kudos to the new wish? ; )
Re: Col N Categories (:green_heart:) - Status changed to: DeliveredRe: Col N Categories (:green_heart:) - Status changed to: Delivered
