This content has been marked as final. Show 2 replies
could you help me with an expression i need to write?
i have to count(distinct (subscriptions.email)) but if (count(deal_externals.deal_external_id)) > 1, and if subscriptions.email = users.email
so, the value of the expression should be 1.
I don't know even if the experssion (count(deal_externals.deal_external_id)) > 1 is wright, i need to count how many deal_external_id has some user.
user 566 has two deal_external_id
user 555 has one deal_external_id
thanks for any advice