EZ Exporter Update: Grouping and Aggregation Now Supports a LIST() Function
In addition to the MIN, MAX, SUM, MEAN, COUNT, and UNIQUE COUNT functions, EZ Exporter also now supports a LIST function.
This new function allows you to combine a group of field values in a JSON list/array. If you're familiar with SQL, this is similar to MySQL's GROUP_CONCAT() function or PostgreSQL's STRING_AGG() function.
This enables creating summary reports where you can include a column including a comma-separated list of values from a grouped data.
Some examples:
- Group orders by product …