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.



    • 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

      Any PMA user can generate an API key. API access is now available to all PMA users; it was previously limited to the Custom plan. This article shows you how to create new credentials so you can authenticate your requests to the Power My Analytics ...

    • 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. Data Studio Select a chart that contains ...

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

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