Help

Displaying Diversity Data Using Pie Chart

688 2
cancel
Showing results for 
Search instead for 
Did you mean: 
BlueOwl
4 - Data Explorer
4 - Data Explorer

I'm working on a project wherein I'm trying to display the diversity characteristics of several universities (50+). I have an existing base with a list of all the universities I'm studying with various facets as fields across (location, size, focus, student life comments, admission criteria etc), but I also wanted to include information on the demographic makeup of each school. Ex: X University is 25% White, 15% Black, 10% Latino, and so on. What's the most efficient way to go about this so that this is also able to be displayed as pie chart via the Charts extension? I started by making an additional base, but as a beginner user I stumbled trying to find a usable format that allowed for readability and reporting. 

2 Replies 2
auekk2787
6 - Interface Innovator
6 - Interface Innovator

Same question - did anyone have a suggestion?

auekk2787
6 - Interface Innovator
6 - Interface Innovator

I've posted my solution in this thread. I created a sub-table for demographics, with a repeating set of demographic groups.

https://community.airtable.com/t5/base-design/tracking-demographics-without-individual-records/td-p/...