Sort Table Aggregations

[jmlowden]

Doesn’t the query sort order get reflected in the unique values aggregation result? So as long as you have a query that sorts by the same field as your unqiue values aggregation, you should be fine…unless you have many records with the same value in that field, and run up against a query limit where potentially your aggregation could only have the one unique value, despite there being other unique values in the that column in the table…

Unique Values from Table w/ >1000 Records?

Is there a workaround to the 1000-record limit for queries/aggregations that would let me get a list of unique values for specific column of a table with more than 1000 records? My table has ~27k records but the column in question has only a couple dozen unique values in it. The goal would be to populate a single-select list which would in turn be used in-app to filter a interactive table widget via table query.