AnsweredAssumed Answered

How to count the number of times a value is chosen in a field.

Question asked by tap4pat on Jan 21, 2019
Latest reply on Jan 21, 2019 by LaRetta_1

I have a field called status that can essentially have three answers: Canceled, No Response, or it can be left blank. I have a found set of 15 records. Four of the records have "No Response", one "Canceled", and the remaining ten are blank. Ultimately I want to calculate the percentage of events responded to.

 

Here is what I have done. I have a field that says what the event type is. I have the report in a list. I have a field in the Grand Summary that gives me a sum of count of the count of the event type (lets just say "Meeting"). I have the result of 15, since there were 15 records.

 

I am having trouble extracting the number of "No Response" and the "Canceled" from my from my status field.

 

I am not sure if I should be making Global Fields, or what to do. I have tried using Values, and Count

Outcomes