COUNTUNIQUEOF function

Prev Next

​​​Description

Returns the number of unique non-BLANK items of a Block.

Syntax

COUNTUNIQUEOF(Block)

Arguments

Argument

Type

Dimensions

Description

Block

(required)

Any

Any

Returns

Type

Dimensions

Integer

No Dimension

Examples

Employee is a Dimension List:

Formula

Result

Description

COUNTALLOF(Employee)

4

The Employee List contains 4 items. All items in a list are counted as unique.

COUNTALLOF(Employee.Name)

3

The Property Name contains 3 unique items.

COUNTUNIQUEOF(Employee.Team)

2

The Property Team contains 2 unique items.

See also

Related articles: COUNTOF, COUNTALLOF, COUNTBLANKOF

More of a hands-on learner?

Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!

​