Can you post a sample data set?
Are the defects in a different column?
for sake of discussion (we can't post real data), the table would be something like this:
Note the omitted gadget ID means those don't have any recorded defects.
I am trying to answer "defect occurred every n gadgets". What is n?
sample data.xlsx 11.6 KB
Would just finding the total sum of DefectCount get you the desired results? By creating a calculated field similar to the following: