AnsweredAssumed Answered

Count if by group in map

Question asked by george.chai on Mar 9, 2016
Latest reply on Mar 9, 2016 by Lee Sobotkin

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?

Outcomes