Count values

29755 — Sat, 10 Jun 2023 20:46:12 GMT

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

Re: Count values

jthi — Wed, 28 Jul 2021 06:35:40 GMT

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.