Building and Using Dashboards > Dashboard Function Reference > Tabular Functions > Distinct Values
Distinct Values
Returns a table with a single column that lists all unique values from a specified column of a specified table.
Arguments
This function has the following arguments:
*Table: Table that contains the column whose unique values are to be returned
*Column Name: Name of the column whose unique values are to be returned
*Sort Values: Numeric value that controls whether the returned values are sorted. Set this to 1 in order to sort the values. Values are sorted in numerical order, if all values are numbers; otherwise they are sorted alphabetically.
*Sort Descending: Numeric value that controls whether the returned values are sorted in descending order, if Sort Values is set to 1. Set Sort Descending to 1 in order to sort the values in descending order. Set the argument to 0 (or leave it blank) in order to sort the values in ascending order.
*Use Column Name: Numeric value that controls the label of the returned column. Set this argument to 1 in order to use the original column name (the value of the Column Name argument). Set the argument to 0 (or leave it blank) in order to use the name Values. Use a generic name when you want a display that is independent of the value of Table, for example, because the value of Table uses a substitution that causes column names to change when the substitution changes.
This function returns a table.
Copyright © 2013-2015 Software AG, Darmstadt, Germany and/or Software AG USA Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Use, reproduction, transfer, publication or disclosure is prohibited except as specifically provided for in your License Agreement with Software AG.