Open Forum

 View Only
  • 1.  Cross Event Report - Complicated Advanced Criteria

    Posted 08-14-2024 16:02

    My report is pulled from the MRF, so date needs to be "Any." I used Advanced Criteria to limit start and end dates to include all 2024 events. 

    I also need to filter out any events that are not in the USA, however some events have that field blank. I need those included in my report. I can't see a way to use "or" in this section. The other section needs to be set to "All," not "Any," however there doesn't seem to be a way to separate the two sections.

    I'm missing about 125 events in my report. Can anyone help?


    #Reporting

    ------------------------------
    Carey (my nickname)

    Anne Carey
    Manager, Compliance
    For: Boehringer Ingelheim GmbH
    ------------------------------


  • 2.  RE: Cross Event Report - Complicated Advanced Criteria

    Posted 08-16-2024 12:28

    Hi Anne - 

    Rather than use the Advanced Criteria section to filter information out, under Data, go to Filter Report Data instead. 

    This will allow you to submit the criteria that you need for each separate field:

    In your example, you can allow for the event start dates as well as select which regions to include or exclude from your report.  

    In case you don't see the field that you want to filter off of, you may need to click the pencil in the top  right corner and toggle that field on, in order to use it on your filters.

    Hope this helps!



    ------------------------------
    Rebecca Yousif
    Senior Administrator - Event Technology
    ------------------------------



  • 3.  RE: Cross Event Report - Complicated Advanced Criteria
    Best Answer

    Posted 29 days ago

    Thank you, Rebecca. It worked!



    ------------------------------
    Carey (my nickname)

    Anne Carey
    Manager, Compliance
    For: Boehringer Ingelheim GmbH
    ------------------------------