The database contains responses from online surveys submitted by customers of our software product. I am brand new to Zoho Creator and Deluge and I'm stuck on something I assumed would be easy. It probably IS easy but I could use some help. 

The records in my file contain three fields that I would like to count.

• Field 1 - "Edition". This field might contain 7 different values and it might be blank.
• Field 2 = "NPS_Score". This field might also be blank or it may contain numbers ranging from 1 - 11.
• Field 3 = "Category" This field contains values such as "Faster Bug Fixes, Better Telephone Support, Missing Feature xyz, etc. This field is populated using a Multi Select field type.

I have one Form so far "Sheet1" that contains all of the fields, including the "Edition" and "NPS_Score" fields.

I would like to create a view and generate a report showing a count of the number of records for each Edition and possibly ranked by the NPS_Score.

I would also like to display a count of records within each Edition containing unique categories.

• e.g. The Dance Edition contains 125 entries. 50 have NPS scores of 7 or above. 75 are categorized with "Better Support,": 50 = Category of "Faster Bug Fixes, etc.

Rather than hard code the criteria, I'd really like to create a form that allowed us to fill in the search criterian for one or more fields - generating reports accordingly.

I've read about 20 of the discussions on this forum that reference the Count function but I'm still lost.

Any help would be appreciated. I'm happy to read a detailed explanation.

Scott C.