for this week’s Tip of the Week, we wanted to share how you can create an Array of Unique values from a list in a column in your Table. this features enables many interesting use cases - you may want to display all the Users working on a specific product, the dates in which you have upcoming shipments, or display the results of an audit procedure you did in your operations. with any Column in your Table, you can now easily find the unique values within an organized (filtered, sorted, etc.) set of Table Records.
here’s a guide on how to do this:
- create a Table query with the Filters, Sorting and Limits you’d like to set:
- add a Table Aggregation, select the Unique as the Calculation and the Column you’d like to find Unique values for:
- once you display the Aggregation in your App, you’ll see an Array of Values available for use:
hope this helps, let us know if you have any questions!!