Answers.Body: <p>Here's <a href="https://dmaster.demo.civicrm.org/civicrm/admin/search#/create/Contact?params=%7B%22version%22:4,%22select%22:%5B%22gender_id:label%22,%22COUNT(id)%20AS%20COUNT_id%22%5D,%22orderBy%22:%7B%7D,%22where%22:%5B%5D,%22groupBy%22:%5B%22gender_id%22%5D,%22join%22:%5B%5D,%22having%22:%5B%5D%7D" rel="nofollow noreferrer">an example</a> showing how you could get counts by gender using SearchKit on dmaster:</p>
  <p><a href="https://i.sstatic.net/eXSHC.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/eXSHC.png" alt="enter image description here" /></a></p>
  <p>You probably want to add some 'Where' clauses to limit the counts to those of interest.</p>
  <p>In general, 'changes over time' reports are harder because you need historic data and Civi primarily reflects the current state. One option is to record the current state over time and compare it outside of Civi.  Other approaches make use of logging to determine the state at a previous time - eg <a href="https://civicrm.org/blog/agilewarejustinfreeman/how-many-members-did-we-have-date-how-many-times-has-member-renewed-how" rel="nofollow noreferrer">this blog post.</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-11-25T12:11:55.887Z
Answers.Text: Thank you, this will work perfectly for me for the time being, and I am happy to work with more complex stuff in excel...
Answers.UserDisplayName: Bern
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-11-23T09:14:35.957Z
Answers.LastActivityDate: 2021-11-23T09:14:35.957Z
Answers.UserDisplayName: Aidan
Body: <p>We need to report on various demographics (gender, age, sexuality, ethnicity, etc...) and changes over time...</p>
  <p>So far, I seem to only manage to produce lists of individuals / contacts that match each of the criteria, but how would I go about producing a report that answers these types of questions:</p>
  <p>How many new BAME* joined our charity between 1st April and 30th June (*sorry, that's british for ethnic minority)</p>
  <p>Or how many members identify as male, female, trans F, trans M, non-binary etc</p>
  <p>I am panicking that this is not even possible within Civi...</p>
  <p>I've tried creating groups, searches within groups, searches using advanced search and search builder, reports...</p>
  <p>As mentioned in my first post, I am a complete newbie</p>
  <p>thanks for any advice</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-11-23T04:18:39.960Z
Comments.Text: What CMS are you using. TBH if this was me, and I was using Drupal, I would just whip them up via Views
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-11-23T04:19:14.630Z
Comments.Text: also worth familiarising  yourself with SearchKit which is in more recent releases of CiviCRM
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-11-23T04:21:23.817Z
Comments.Text: https://civicrm.org/blog/awestbha/using-search-kit-wild-0
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-11-24T06:57:46.893Z
Comments.Text: Our Civi is hosted on Drupal - sounds I have to learn that on top of learning Civi.... I have read something about 'views' and will need to go learn in depth
Comments.UserDisplayName: Bern
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-11-24T06:59:26.573Z
Comments.Text: also SearchKit... given the example shown below, looks like it could provide me with what I need. I am happy to then take into Excel for further complex manipulation - Thank you for info!
Comments.UserDisplayName: Bern
Tags: <reports><searchkit>
Title: How do you create reports that show the number of
ThreadText: # How do you create reports that show the number of
  
  (Asked by: username_0 on 2021-11-22)
  
  We need to report on various demographics (gender, age, sexuality, ethnicity, etc...) and changes over time...
  
  So far, I seem to only manage to produce lists of individuals / contacts that match each of the criteria, but how would I go about producing a report that answers these types of questions:
  
  How many new BAME\* joined our charity between 1st April and 30th June (\*sorry, that's british for ethnic minority)
  
  Or how many members identify as male, female, trans F, trans M, non-binary etc
  
  I am panicking that this is not even possible within Civi...
  
  I've tried creating groups, searches within groups, searches using advanced search and search builder, reports...
  
  As mentioned in my first post, I am a complete newbie
  
  thanks for any advice
  
  **Tags:** reports, searchkit
  
  > **Comments:**
  > **username_1**: What CMS are you using. TBH if this was me, and I was using Drupal, I would just whip them up via Views  
  > **username_1**: also worth familiarising  yourself with SearchKit which is in more recent releases of CiviCRM  
  > **username_1**: https://civicrm.org/blog/awestbha/using-search-kit-wild-0  
  > **username_0**: Our Civi is hosted on Drupal - sounds I have to learn that on top of learning Civi.... I have read something about 'views' and will need to go learn in depth  
  > **username_0**: also SearchKit... given the example shown below, looks like it could provide me with what I need. I am happy to then take into Excel for further complex manipulation - Thank you for info!  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2021-11-23. Score: 2 | Accepted answer
  
  Here's [an example](https://dmaster.demo.civicrm.org/civicrm/admin/search#/create/Contact?params=%7B%22version%22:4,%22select%22:%5B%22gender_id:label%22,%22COUNT(id)%20AS%20COUNT_id%22%5D,%22orderBy%22:%7B%7D,%22where%22:%5B%5D,%22groupBy%22:%5B%22gender_id%22%5D,%22join%22:%5B%5D,%22having%22:%5B%5D%7D) showing how you could get counts by gender using SearchKit on dmaster:
  
  [![enter image description here](https://i.sstatic.net/eXSHC.png)](https://i.sstatic.net/eXSHC.png)
  
  You probably want to add some 'Where' clauses to limit the counts to those of interest.
  
  In general, 'changes over time' reports are harder because you need historic data and Civi primarily reflects the current state. One option is to record the current state over time and compare it outside of Civi. Other approaches make use of logging to determine the state at a previous time - eg [this blog post.](https://civicrm.org/blog/agilewarejustinfreeman/how-many-members-did-we-have-date-how-many-times-has-member-renewed-how)
  
  > **Comments:**
  > **username_0**: Thank you, this will work perfectly for me for the time being, and I am happy to work with more complex stuff in excel...  
  
  ---
  
  