How to count get counts for multi Select Fields
I have requirements that have a multi value select field. how can i count the number of instances of the selected values?
So lets say
I need to count like this:
I think it is a matter of counting how many of each item there are.
First I would make one long string such as:
Maybe a dictionary object would be useful here.
Go through one item at a time. If it is a new one, create a new key and the item is 1,
If the key exists, bump up the item count.
After the scan cycle through the dictionary to get out the count of each.
I have not tried it. It may work.
I hope that I am answering your question.
I am not sure what a multi value select field is.
In an excel report you could probably join from the all_lists table for the list you are interested in to the req table using a like rather than = in the where/on clause. That way if the list changes or gets longer your query doesn't have to change. Then use a group by on the list value and a count to get the final result.