# How to Create Working Age and Gender Charts

---

***Many of our clients have difficulty creating age and gender charts in their reports. This article will tell you everything you need to know to create a functioning age or gender table with most connectors.***

---

## Match \[collection\] fields

Most demographic data comes in collections. \[Collection\] fields come in pairs and will have the same names. The [Schema Explorer](https://hub.powermyanalytics.com/resources/schema) in your Hub can be used to find them.

![](https://knowledge.powermyanalytics.com/application/troubleshooting/images/how-to-set-up-age-and-gender-charts-1.png)

On some connectors, these are Key/Value pairs where the Key must be set as a dimension and the Value as a metric.

![](https://knowledge.powermyanalytics.com/application/troubleshooting/images/how-to-set-up-age-and-gender-charts-2.png)

On other connectors, they are labeled as dimensions and metrics.

![](https://knowledge.powermyanalytics.com/application/troubleshooting/images/how-to-set-up-age-and-gender-charts-3.png)

## Do not add fields from different collections

Combining fields from different collections will result in [Community Connector Error: Invalid Combination with a Collection](https://knowledge.powermyanalytics.com/application/troubleshooting/community-connnector-error-invalid-combination-with-a-collection/).

![](https://knowledge.powermyanalytics.com/application/troubleshooting/images/how-to-set-up-age-and-gender-charts-4.png)
