Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a the following structure:
I am trying to get this using an expression :
count the number of Contact IDs for each target, like this :
IF A CONTACT HAS ONE TARGET COUNT ONLY THE 1ST NON EMPTY
IF A CONTACT HAS MANY TARGETS (ex: CONTACTID => 4) COUNT ONLY THE 1ST NON EMPTY WITH LATEST DATE
ALSO, I NEED TO COUNT Contact IDs WITH NO TARGET
so the results would be :
if i use only count(target) i'm getting this :
I am trying to get this done with Set analysis but no results :-((:
Thanks;