UniqueValues function

Applies to: TBM Studio 12.0 and later

Returns a list of unique values in a column.

Where to use

This function can be used in:

Data sets
Formula columns in report tables
Dynamic text
Any place where you can add a condition filtering clause.

Note: This function cannot be placed in a column in the same table that is referenced in the function. If you attempt to do this, you will get an error message.

Syntax

UniqueValues(table:column,true[table:column = table:column])

Arguments

column

The column to examine for distinct values.

true

If this parameter is included, blank and null values will be excluded from the list.

For example, assume you have the following data:

Col A	Col B
F1	A
F2	B
F3

If you specify =UniqueValues(ColB), you will get: null,A,B.

If you specify =UniqueValues(ColB,true), you will get: A,B.

filter query

If a match criterion in brackets [ ] is added after the table:column specification, the return values are limited to values which match between two tables.

Return type

Comma separated list of unique values in the designated column.

Example

Assume you have the table below:

Server	Location
EXCH006	Seattle
EXCH010	Boston
NET207	Boston
STOR124	Seattle
STOR250	Boston
STOR350	Denver

The following function, if executed against the Servers table above, returns three values: Seattle, Boston, Denver.

=UniqueValues(Servers:Location)

Another application of this function is to return a list of concatenated email addresses from a column in a table to use with the SendMail Apptio Script API.