Welcome to Catalog Tips

Search more than 200 articles to learn more about creating and automating your product catalogs

Tip: Start typing in the input box for immediate search results.

< All Topics
Print

GROUPCOUNTUNIQUE – Count unique instances of field content

Overview

This Custom Field returns the number of unique instances of a fields content in a group

Syntax

GROUPCOUNTUNIQUE(‘Parent Category:Child Category’,‘Manufacturer’)

Element Description
‘Parent Category:Child Category’ Group path, delimited by colons
‘Manufacturer’ Field in which to count instances

Examples

For the table below, GROUPCOUNTUNIQUE(‘Category1ID:Category2ID:CollectionID’) will return 2 as there are 2 distinct/unique CollectionID rows.

Category1ID Category2ID CollectionID ProductName Price
25 136 1924 Apple 9.99
25 136 1924 Banana 11.00
25 136 1965 Cantaloupe 48.95
25 136 1965 Durian 29.99

See also

GROUPCOUNT

GROUPAVG

GROUPMAX

GROUPMIN

GROUPSUM

GROUPRTOTAL

GROUPFIRST

GROUPLAST

GROUPISFIRST

GROUPISLAST

Table of Contents