topic Re: OR between two expressions in App Development

OR between two expressions

50ShadesOfSalty — Fri, 30 Apr 2021 14:29:15 GMT

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!

Re: OR between two expressions

GaryGiles — Fri, 30 Apr 2021 15:05:45 GMT

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])

Re: OR between two expressions

jwjackso — Fri, 30 Apr 2021 15:06:48 GMT

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])

Re: OR between two expressions

50ShadesOfSalty — Fri, 30 Apr 2021 15:20:52 GMT

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!