Pigment AI Agents are here! Starting today, we’re launching new AI Agents and updating our documentation for them. Some pages may look different or redirect to new resources. Send us feedback through "Was this article helpful?" at the foot of the page

COUNTUNIQUEOF function

  • Published on Aug 22, 2025
  • 1 minute(s) read
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!

​

Related articles