distinctCount

Last update: January 29, 2024

CREATED FOR:

  • Experienced
  • Developer

Counts the number of different values ignoring the null values.

Category

Aggregation

Function syntax

distinctCount(<listAny>)

Parameters

ParameterTypeDescription
listToProcesslistString, listBoolean, listInteger, listDecimal, listDuration, listDateTime, listDateTimeOnly, listDateOnly, or listObjectList to process. For listObject, it must be a field reference.
keyAttributeNamestringThis parameter is optional and only for listObject. If the parameter is not provided, an object is considered as duplicated if all the attributes have the same values. Otherwise, an object is considered as duplicated if the given attribute has the same value.

Signature and returned type

distinctCount(<listAny>)

Returns an integer.

distinctCount(<listObject>)

distinctCount(<listObject>,<string>)

Returns a list of objects.

Example

distinctCount([10,2,10,null])

Returns 2.

distinctCount(@event{my_event.productListItems})

Returns the number of strictly distinct objects in the given array of objects (listObject type).

distinctCount(@event{my_event.productListItems}, "SKU")

Returns the number of objects which have a distinct “SKU” attribute value{}.

Previous pagecountWithNull
Next pagedistinctCountWithNull

Journey Optimizer