Connector Error: Can’t Mix and Match Fields from Different Tables

Connector Error: Can’t Mix and Match Fields from Different Tables

This article will help you to solve the following error:

"Community Connector Error: PMA Error | Can't mix and match fields from different tables" 



"Invalid configuration: Invalid combination of metrics and dimensions"




Cause

You will receive this error when you have attempted to create a chart with two or more fields that do not share a common table. It is important to ensure that all fields in a chart have at least one common table.

Solution

In your Hub, click Schema Explorer under Tools in the left navigation pane.



  1. Select the connector you would like to use
  2. Choose the fields you'd like to include.
  3. We will remove incompatible fields from the list and display the number of fields that remain.





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