Reporting: Count Picklist records?
I have 5 picklist fields within one lead. All with 3 options which contain qualitative values, not quantitative (text values)
- FIeld1 - Option 1, Option 2, Option 3
- Field2 - Option 1, Option 2, Option 3
- Field3 - Option 1, Option 2, Option 3
- Field4 - Option 1, Option 2, Option 3
- Field5 - Option 1, Option 2, Option 3
I'm trying to create either a Report or an Analytics chart that counts how many FIELDS and how many leads have "Option 1" selected, How many are "option 2" and how many "Option 3".
For example,
if these are the values in LEAD-A.
- FIeld1 - Option 1
- Field2 - Option 1
- Field3 - Option 2
- Field4 - Option 2
- Field5 - Option 1
And these are values in LEAD-B.
- FIeld1 - Option 1
- Field2 - Option 3
- Field3 - Option 3
- Field4 - Option 3
- Field5 - Option 3
> The report would show that a total of 4 fields had Option A, 2 fields have Option B, and 4 fields have option 3.
> A different report would show that 2 leads have option A, 1 lead has option B, and 2 have Option C.
Doing this would require the ability to count the total current lead fields with these picklist values and not just how many leads have a field with this value. How can this be done?