nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

how to Calculate every abnormal item rate by days？

TONYMA

dear all；

i want to Calculate every abnormal item rate，in excel i can do it。（excel file ）

but in jmp i can use ”summary of table“ to calculate sum of abnormal items rate only。（JMP file）

how i select summary to Calculate every abnormal item rate？

and if JSL has some， i want to you teach me，

thank you。

JMP2.jmp

JMP1.jmp

excel chart.xlsx

Accepted answers

dale_lehman

As I described, you make the tabulate into a data table and create a column for the defect rate - this is what I've attached. I also included several versions of graphical displays of the defect rate for each type of defect over time. The displays can be improved (and should be) further - your Excel graph also needs improvement. You will notice that a number of defect types only occur once, so you might consider recoding those as "other" which will considerably improve the graph by reducing the number of categories.

example2.jmp

All comments

dale_lehman

I converted your Excel data worksheet into a JMP data table, added a new column and did a Tabulate (execute the script added to the data table). If you use the drop down arrow and "Make into data table" the executed Tabuulate script, you can easily add a column calculating the defect types as a % of the total items for each day, reproducing what you have in your Excel workbook.

example solution.jmp

TONYMA

thank you for your answer，

but i am sorry ，and i want to calculate every abnormal item rate like my excel chart。

couid you calculate again to show chart like my excel chart？

図1.jpg

dale_lehman

example2.jmp