Special groupbys are optional string values that can be appended to a column name to request a more specific grouping.
For each of the special group bys, a .key aggregate must be selected to properly match the result data with its special group type.
Group a string column by the record's first letter. For example, if there is a table with names, a query can be written to determine how many names begin with A.Learn more link
Group data in a numeric column by a set of rules. For example, This is useful for grouping data into custom ranges. For example, groupby rules cna be used to write a query that would sum all political donations ranging from $0 to $1,000, $1,000 to $10,0000, $10,000 to $100,000 etc.