Formula or summary report to show count of occurrances of a specific entry

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
I am trying to create a field (numeric - formula) that will total the amount of times a specific field is referenced.

My app is used to monitor in process inspection. There are 20+ different types of defects that a user can choose to log. These are all found in a multiple choice pulldown field named "Defect Category".

i.e.

1 - defective crimp

2 - defective overmold

3 - etc



I want to be able to make a chart which keeps track of the amount of defects per category, per month.

I also need a chart which keeps track of each employee and the amount of defects they incur. Either way, I need to be able to create a countif formula but cannot figure out how to do it. Any help would be appreciated. Please note, a summary chart will not suffice. I am hoping I do not need to create fields for each "defect category". Not sure either if a summary field will work since all my data is on one table "all defects"



Thanks!

Photo of mkosek

mkosek

  • 928 Points 500 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Photo of mkosek

mkosek

  • 928 Points 500 badge 2x thumb
answered