topic Set Analysis - Uniques in Data Movement & Streaming

Set Analysis - Uniques

patagbura — Wed, 19 Mar 2025 23:06:21 GMT

I have a set analysis formula counting Sales from “Germany” as follows:

(Count({<[Country]={‘Germany}>} Sales))

I would like to however only consider the uniques of a third column called “Submissions”. The current selection double counts Submissions.

How might I go about removing all duplicates of a third column / submissions column?

BrunPierre — Wed, 16 Nov 2022 21:52:57 GMT

Maybe like this

Count({<[Country]={‘Germany},Submissions ={"=Count(DISTINCT Submissions)"}>} Sales)

marcus_sommer — Thu, 17 Nov 2022 07:46:42 GMT

You may try:

Count({<[Country]={‘Germany}>} distinct Submissions)

or if no relevant field like an OrderID exists also the combination of fields like:

Count({<[Country]={‘Germany}>} distinct Sales&Submissions)

An alternatively might also be to use two expressions to get the unique count, like:

count(distinct Sales) / count(distinct SalesLines)

- Marcus