Special groupbys

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.

Types

Groupby First Letter

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
Groupby Rules

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.

More Special Groupbys