Please attach sample data as twbx and clarify your expectation with actual value example.
1 of 1 people found this helpful
It's quite difficult to speculate what you really need, but from below data set, I am guessing.
Defect (counting event number) per Machine (= Serial No) by Day.
Then try to capture the distribution of above plot i month??
Plot is average (defects per (serial number x date)) per month by Serial Number.(average of multiple "date")
This orange is the avg of (defects per (serial number x date)) per month (not considering machine average).
If you need defect count by machine by month, the formula will be different (red and sheet9), but anyways,
I am not sure about the real expectations regarding what is the smallest unit (defect per unit = by day or month or whatever else) you want to get distributions...
This is fantastic. Your solutions have given me a few other ideas on which directions I can go with my data. I really appreciate your help on this.
Glad that I could help you.