Set Analysis - Uniques

drankfe5 — Mon, 22 Apr 2024 08:59:37 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?

TIA!

Re: Set Analysis - Uniques

marcus_sommer — Mon, 22 Apr 2024 11:31:16 GMT

Maybe you could use something like this:

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

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