Solved

Uniques for multiple events

  • 26 October 2021
  • 2 replies
  • 95 views

Badge

I want to measure the number of unique users per month who performed EITHER of several events. Do I just use 

UNIQUES(A)+UNIQUES(B)+UNIQUES(C)

or would that still hold duplicate users (counts per event and just adds, or deduplicate as well)?

icon

Best answer by Saish Redkar 26 October 2021, 16:33

View original

2 replies

Userlevel 7
Badge +10

Hey @razf6,
Creating a custom event will be the ideal approach to measure the “number of unique users per month who performed EITHER of several events” use case. 

I believe that the formula approach of UNIQUES(A)+UNIQUES(B)+UNIQUES(C) will just perform pure arithmetic sum of the unique counts without any deduplication.

Let me know if I have interpreted your use case correctly. Hope this helps.

 

Badge

Yes, played with this some more after posing here, you are right (both as to the custom event approach, and as to the “pure arithmetic sum” my original solution does).

 

Thanks

Reply