BASE DE DADOS DE CONHECIMENTO

Error: "Calculations containing user functions cannot reference fields from Physical Tables"


Publicado: 22 Oct 2020
Data da última modificação: 10 Jul 2023

Problemas

Upon creating/editing a calculation field, the following error occurs:

Error: "Calculations containing user functions cannot reference fields from Physical Tables"


User-added image

Ambiente

  • Tableau Desktop 2020.2.0 and later

Resolução

Change Relationship to Join in the data source.

For example, the Orders and People are different logical tables below.
User-added image

since Customer Name is from Orders table while Person is from People table, the following error occurs.
User-added image

Change Orders and People from Relationship to Join like below: 
User-added image

then the calculation is valid.
User-added image
 

Causa

User functions cannot be used in a calculation referring fields from different logical tables.
 
Este artigo resolveu o problema?