how to count the frequency of error code in a column in a data base
This widget could not be displayed.
Created:
Jul 18, 2024 09:12 AM
| Last Modified: Jul 18, 2024 6:12 AM(531 views)
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
Re: how to count the frequency of error code in a column in a data base
This widget could not be displayed.
Created:
Jul 18, 2024 09:16 AM
| Last Modified: Jul 18, 2024 6:16 AM(525 views)
| Posted in reply to message from Yass 07-18-2024
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
This widget could not be displayed.
Created:
Jul 18, 2024 10:04 AM
| Last Modified: Jul 18, 2024 7:04 AM(511 views)
| Posted in reply to message from jthi 07-18-2024
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
This widget could not be displayed.
Created:
Jul 18, 2024 10:20 AM
| Last Modified: Jul 18, 2024 7:20 AM(466 views)
| Posted in reply to message from Yass 07-18-2024
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.