I have a survey database which consists of a form with 3 fields. What I need to do is get the total number of unique values for all fields. This is easy enough to do with a categorized view and a computed column with a value of “1” and totals enabled. Here’s the rub - I need to sort by total, so the field values that are submitted most often appear at the top of the view. Is there any way to do this short of looping through all the documents and loading arrays to get the count for each value? I’m trying to keep it as simple as possible.
That would work, but I’m trying to keep the solution as simple as possible and would prefer to let the users get all information directly from one place.