Skip to main content
Topics#Reports & DashboardsFrage von Frank Woodward
Frank Woodward fragte in #Reports & Dashboards
21. Aug. 2020, 15:01

Reporting filter: All Contacts with Activities not related to a Campaign

I'd like to add a cross filter to a Contacts & Organizations report, showing contacts that have no Activities that are related to a given campaign code. However, because a contact can have multiple activities, I'm having trouble determining the correct logic to use - I want to report only contacts for which every Activity (as opposed to any activity) is not Related To the campaign code. 

 

How do I add the "with every...not equal to" logic in a report filter?
2 Antworten
  1. Chloé Courtois (Doctolib)
    21. Aug. 2020, 15:14

    Hi Frank

    In that case I would try the opposite : what you want is to look at all without a campaign

     

    So that would be something like "Activities without a campaign not equal to "" (null)"

     

    Does that make sense? :)

     

    Chloé
Antwort schreiben...
0/9000