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 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 ...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 ...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 ...Pinterest Ads Data Connector User Guide
The following article is a guide to automating reports with your Pinterest Ads connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Pinterest Ads reports. To begin ...