Enhance the advanced functions in Aha! to list unique values from a string field

What is the challenge?

The primary challenge we are facing is the presence of duplicate values in the lists generated by our custom field formula. We have a custom field in our feature layout that pulls values from a specific column in a related custom table for each feature using the formula:

What is the impact?

Duplicate values in custom field and the feature view looks messy

Describe your idea

Current Scenario:

In our feature layout, we have a custom field that pulls values from a specific column in a related custom table for each feature. The custom field formula we are currently using is:

=self.custom.cpi_test_link_cp[].custom.lob_jj

While this formula successfully retrieves the required values, it results in a list that includes duplicate entries. These duplicates can lead to confusion and inaccuracies in our data analysis and reporting.

Proposed Enhancement:

We propose the addition of a built-in function that can be used within custom field formulas to remove duplicate values from the list. This would streamline our data and ensure that each value is unique.

Example Syntax:

An example of how this function might be integrated into our existing formula could be:

=unique(self.custom.cpi_test_link_cp[].custom.lob_jj)

PFA for sample screenshot.