how to count the frequency of error code in a column in a data base

[#1]

Hello,

I am trying to create a Pareto diagram in JMP, but in my data table, I don't have the frequency of code errors (which are defined as a list of integers from 0 to 1010). I am looking for a way to count these directly in JMP as a new column.
I found the "Row > Count" function in the formula section, but I don't know how to use it

Best regards,
Thank you.

[#2]

Depending on your data, maybe Col Sum() or Col Number()? Also if you just need the diagram you might be able to do the calculation directly in Graph Builder (or Pareto Plot) or you might want to utilize Summary table and create report from that.

[#3 · Accepted solution]

if i want to use the pareto plot directly i need the freq (PPM) i think

[#4 · Accepted solution]

It is not necessary to use that (it does say optional).

If I have data like this

I can get pareto like this in Pareto Plot platform

But like I said, it depends on your data

[#5]

Ah okay, I understand now. Is there a method to use only the selected rows (filtered by Date greater than or equal to 2024-07-01) instead of using all rows for pareto?

[#6]

You could add Local Data Filter to Pareto Plot (or Data Filter to data table). Or you can invert the row selection and then hide and exclude those rows.

[#7]

okey thank you so much for your help.