I propose adding a function similar to Spark SQL's concat_ws(collect_set()) in Incorta Analyzer. This aggregate function would enable users to aggregate and concatenate distinct values from a group into a single string, enhancing data analysis capabilities within Incorta dashboards. Current State: Currently, in order to get a list of values grouped by a particular field, it is required to create a materialized view. Example: Consider a dataset of customer purchases. When grouping by customer and utilizing this new function, it would output a distinct list of all customer ordered products for each customer. Incorporating this functionality would greatly benefit users who need lists aggregated at a variety of levels for additional context in analysis.
... View more