Microsoft Corporation Creates a query that groups results, and returns a count of how many items are in each group and a sum of a specific field. qGroupSum

queryResult item Replace with the identifier for the query. query item item Replace with the identifier for the variable that represents an item from your data source. fruit dataSource String Replace with the identifier for your data source. New String() {"apple", "orange", "pear", "banana"} field String Replace with the name of the field used to group the results. Length groupName String Replace with the alias to give to your group. CharCount aggregateName String Replace with the alias to give to the first aggregate. FruitCount aggregateName2 String Replace with the alias to give to the first aggregate. TotalCharCount groupingCondition String Replace with the first aggregator to call on your group. Count groupingCondition2 String Replace with the second aggregator to call on your group. Sum