Count values

[#1]

Hi all,

I have 2 columns, 1st column is for the parts name (sample: parts 1 and parts 2) then 2nd column is the judgement whether is good or no good.

Is is possible to count all the good parts and place the total good parts for parts 1 & 2 on the next column?

Thanks

[#2]

In most of the cases with JMP you will end up with something like this with all rows getting the same value depending on grouping you use:

Col Sum(If(:Result == "Good", 1, 0), :Part)

I would most likely suggest using Tabulate or Summary. Using the same table:

With tabulate you can get this:

and with summary:

If these are not sufficient enough, could you provide example table (and use case if possible), so better answer can be given.