How to Create Working Age and Gender Charts

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 in your Hub can be used to find them.



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



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



Do not add fields from different collections

Combining fields from different collections will result in Community Connector Error: Invalid Combination with a Collection.