incompatible fields

Looker Q&A Looker Studio
,
1

Hello, I have been using Looker for a short time and it may seem like a stupid question. I am creating a report using the Metricool connector and I have created several calculated fields in which I am simply trying to add up several metrics. My question starts when there are some fields that I have added up and I try to display them in a results table and it tells me that there is no data. Sometimes it tells me that they are incompatible fields and that is something I do not fully understand since they are the same type of field, they have the same aggregation and are from the same data source. Thanks.

2

Hi, here are a few things you can check:

  1. Even if the fields are from the same connector, they might come from different sections (like Audience vs Posts). If so, they won’t work together.

  2. If one of the metrics has no data (null), your formula might break. Try this: “IFNULL(Metric1; 0) + IFNULL(Metric2; 0)”

  3. Make sure your table uses dimensions that all the metrics can work with (like Date or Campaign). If not, data might not show up.

  4. Check if all fields use the same aggregation, like SUM. Mixing can cause errors.

    Hope this helps!