Object set aggregation for string array variable

Ask the Community
1

I have a question about Object set aggregation in Workshop’s Variable.

I am aggregating a property of String type to get a unique value of the property, and using this String Array variable from the aggregation as a choice in the String selector.

However, when the number of aggregated results exceeds 500, all the results are not displayed.(Error meassage “Aggregation limit of 500 reached”)

Is it possible to change this limit of 500 results, or if not, is there another way?

2

With a typescript function, you could do an aggregation and have up to 10,000 bucket values:

@Function()
public async getUniquePropertyValues(myObjectSet: ObjectSet<MyObjectType>): Promise<string[]> {
    const aggregation = await myObjectSet.groupBy(o => o.myProperty.exactValues({"maxBuckets": 10000})).count();
    return aggregation.buckets.map(bucket => bucket.key);
}
4

In the meantime, the limit for unique values aggregations has been increased to 10,000 in Workshop:

image
image1242×962 88.4 KB

5

Another consideration is - just for folks who might find this question - is to use the Filter List widget, which can be configured to act as a single string dropdown (use the Pills display) that provides keywords search and a histogram of top values as part of the selection interaction.

The limitation is the at the output is an Object Set Filter variable, rather than the selected value, so you then need to apply that Filter to a new Object Set variable based on the Filter List input, and, assuming there is more than one resulting object, use an Object Set Aggregation or Variable Transform to “extract” the selected value (assuming you want the value and the whole purpose wasn’t to configure a filter).