When a text field is used as a grouping field in an aggregate query, actual field values are used to form each group value. For example, in this query:If the field Extension has identical but differently-cased values such as “.jpg” and “.JPG”, a group is created for each one and the metric function (COUNT) is applied to each one.When a text field is used as the grouping field, values can be case-normalized as they are used as grouping field values. This can be done with the UPPER and LOWER functions, which translate each text field accordingly as it is sorted into aggregated groups. Example:This causes the Extension field to be down-cased before it is sorted into its metric group. Hence, both values “.jpg” and “.JPG” are counted in a single group.