how to count the frequency of error code in a column in a data base
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.
Advanced Statistical ModelingAutomation and ScriptingContent OrganizationData AccessData Blending and CleanupData Exploration and VisualizationReliability AnalysisRe: how to count the frequency of error code in a column in a data baseDepending 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 baseif 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 baseIt 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 baseAh 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 baseYou 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 baseokey thank you so much for your help.
