Is aggr() the way to create this expression?

Thu, 09 May 2013 18:52:17 GMT

Given a call_fact table as follows:

Call ID	Transaction Key
555-1212	12345
555-1122	6789

And a transaction table (with non-unique keys) as follows:

How would I define an expression that would count all of the calls that Requested Info about a Cruise AND Made a Guaranteed Reservation.

In the above example, the answer should be '1'.

I have a feeling the aggr() function should be employed here, but I'm not sure how.

Thanks.

Re: Is aggr() the way to create this expression?

Gysbert_Wassenaar — Thu, 09 May 2013 19:11:33 GMT

You can do it with a set analysis expression. Something like this:

=count({<Type={'Request Info'},Value={'Cruise'},[Call ID]=p({<Type={'Make Reservation'},Value={'Guarranteed'}>}[Call ID])>} distinct Key)

See attached example.