Answers.Body: <p>That should be doable with 2 joins.</p>
  <ul>
  <li><strong>Search for:</strong> Events</li>
  <li><strong>With (optional):</strong> Participants</li>
  <li><strong>With (optional):</strong> Contacts IF custom field = x</li>
  </ul>
  <p>Counting the first join should give you all participants, and counting the second should give you just the ones with the custom field.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-03-22T03:50:07.080Z
Answers.Text: Thank you!  I had never used the "Contacts IF field = x" construct on the "Search For" tab before.  I don't think I've even seen that you could filter on that tab before.  So thank you!  This totally worked!
Answers.UserDisplayName: richardsplayground
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-03-16T02:46:00.080Z
Answers.LastActivityDate: 2024-03-16T02:46:00.080Z
Answers.UserDisplayName: Coleman
Body: <p>I'm trying to build a table that shows something like this:</p>
  <blockquote>
  <p>EventTitle | EventStart | Total Participants | Count of Participants
  with CustomField=Y</p>
  </blockquote>
  <p>Using searchkit, I can get this easily:</p>
  <blockquote>
  <p>EventTitle | EventStart | Total Participants</p>
  </blockquote>
  <p>and I can also get this easily:</p>
  <blockquote>
  <p>EventTitle | EventStart | Count of Participants with CustomField=Y</p>
  </blockquote>
  <p>But I can't seem to think of a way to both filter on participants who have that custom field but also list all participants.  In the filter tab it seems like I can either filter on these users or not.</p>
  <p>Is there a way to accomplish this?</p>
  
Tags: <searchkit>
Title: How do I show count of all participants and count of participants that meet a criteria (searchkit)
ThreadText: # How do I show count of all participants and count of participants that meet a criteria (searchkit)
  
  (Asked by: username_0 on 2024-03-15)
  
  I'm trying to build a table that shows something like this:
  
  > EventTitle | EventStart | Total Participants | Count of Participants
  > with CustomField=Y
  
  Using searchkit, I can get this easily:
  
  > EventTitle | EventStart | Total Participants
  
  and I can also get this easily:
  
  > EventTitle | EventStart | Count of Participants with CustomField=Y
  
  But I can't seem to think of a way to both filter on participants who have that custom field but also list all participants. In the filter tab it seems like I can either filter on these users or not.
  
  Is there a way to accomplish this?
  
  **Tags:** searchkit
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2024-03-16. Score: 1 | Accepted answer
  
  That should be doable with 2 joins.
  
  * **Search for:** Events
  * **With (optional):** Participants
  * **With (optional):** Contacts IF custom field = x
  
  Counting the first join should give you all participants, and counting the second should give you just the ones with the custom field.
  
  > **Comments:**
  > **username_0**: Thank you!  I had never used the "Contacts IF field = x" construct on the "Search For" tab before.  I don't think I've even seen that you could filter on that tab before.  So thank you!  This totally worked!  
  
  ---
  
  