What would be the best way to go about counting the number of records that will return a specific value such as "Yes" grouped by IDs?
eg. I have an array with 6 Main ID's; of which have 10 Sub ID's attached to each. I want to count how many Sub ID's have the value "Yes" for each Main ID.
Ultimately returning the value of the Main ID along with the count of "Yes" Sub IDs (6 rows).
Is this possible within the map shape?