OR between two expressions

[50ShadesOfSalty]

Good morning everyone,

I have two expressions (from different data sources):

• One counts the number of Sessions
  • Sum([Sessions Counter])
• Other onecounts the number of Interactions
  • Sum([Interactions Counter])

A session is linked to a client (consider, Client ID), as well as a Interaction.

This is where both expressions share the same attribute, Client. 

I want to retrieve the unique number of Clients (Client ID) that had either a Session done OR a Interaction done.

Can someone help me?

Thank you!

[GaryGiles]

We can union 2 sets in set analsysi by using < >+< >.  One set will contain rows where [Sessions Count] is not missing -={} and the other where [Interactions Counter] is not missing:

count($<[Sessions Count]-={}>+<[Interactions Counter]-={}>} Distinct [Client ID])

[jwjackso · Accepted solution]

Try checking if the client has non-null counters

Count({<[Client ID]=P({<[Sessions Counter]={"*"}>}[Client ID])+P({<[Interactions Counter]={"*"}>}[Client ID])>}Distinct [Client ID])

[50ShadesOfSalty]

Thank everyone for the answers, i really apreciate it!

For me, the answer from Jwjackso did the trick! Completely forgot about the possibility of p() in here!

Thank you!