How do you create reports that show the number of

Question

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

Answer 1

Here's an example showing how you could get counts by gender using SearchKit on dmaster:

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.