topic Re: how to count the frequency of error code in a column in a data base in Discussions

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

Yass — Thu, 18 Jul 2024 13:12:10 GMT

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.

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

jthi — Thu, 18 Jul 2024 13:16:44 GMT

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.

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

Yass — Thu, 18 Jul 2024 13:29:15 GMT

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

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

jthi — Thu, 18 Jul 2024 13:38:26 GMT

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

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

Yass — Thu, 18 Jul 2024 14:04:47 GMT

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?

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

jthi — Thu, 18 Jul 2024 14:20:29 GMT

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.

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

Yass — Thu, 18 Jul 2024 14:51:53 GMT

okey thank you so much for your help.