To retrieve a count of distinct, unique occurrences of a data item in the database, use the count distinct aggregate function in the Query section.
- In Query section, double click the intended item on the Request Line (or select item and select Modify).
- Press the Functions… button on right in dialog box.
- Select Aggregate Functions from the Function List Categories window in the Database Functions dialog box.
- Select Count Distinct from the Functions available in the window to the right.
- Click OK in the Database Functions dialog box.
- Click OK in the Item dialog box.
- To review/modify the computed item double click on the item name on the Request Line.
Last updated: October 15, 2013