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.




    Still having issues?
    Send us a ticket and we will get back to you.
      • Related Articles

      • Community Connector Error: Invalid Combination with a Collection

        This article will help to resolve the following community connector errors. Cause This error occurs when two incompatible fields are placed in the same table together. In this example, Total People Who Viewed By Country could not be combined with ...
      • How to Generate a New API Key

        Only accounts with Enterprise subscriptions can generate API keys. This article will show you how to create new credentials. Begin at Your Hub Select Exports from the left navigation pane. Then select API. Click +Create API Key. Your API key will ...
      • How to Filter Out Deleted Deals in Hubspot

        An API limitation in Hubspot makes it impossible to remove deleted deals from your data set. Follow the instructions in this article to learn how to filter out deals that you no longer want in your reports. Looker Studio Select a chart that contains ...
      • Sign Up for Power My Analytics and Create Your Hub

        Are you ready to streamline your marketing data collection and reporting? This guide will walk you through the process of signing up for Power My Analytics and creating your hub. By the end, you'll be set up to automate your marketing data and ...
      • Looker Studio Demo Template Guide

        When connecting to Looker Studio, there are a few best practices to keep in mind. From demo templates to customizations to troubleshooting, this guide will teach you some pro tips for using Power My Analytics data connectors. Use a Demo Power My ...