count(distinct val)

[#1]

Hello All,

Any function in  Jmp similar to count distinct in sql?

Examples:

How can I obtain the values of count distinct subjectsid in a new column in these tables with functions?

Thanks

TABLA 1               

subjectid             count distinct subjectid

a                                              5

b                                             5

c                                              5

a                                              5

b                                             5

d                                             5

e                                             5

TABLA 2               

subjectid             count distinct subjectid

a                                              3

b                                             3

c                                              3

a                                              3

[#2]

JMP19 will provide a new function to calculate Col N Categories - actually: Col N Unique()
https://community.jmp.com/t5/JMP-Wish-List/Col-N-Categories/idc-p/870972/highlight/true#M7292 

... and via the new column menu it will be available in every report - like Graph Builder.