Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Displaying Diversity Data Using Pie Chart

1379 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
7 - App Architect
7 - App Architect

Same question - did anyone have a suggestion?

auekk2787
7 - App Architect
7 - App Architect

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/...