知識庫

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


發佈時間 : 22 Oct 2020
上次修改日期 : 10 Jul 2023

問題

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

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


User-added image

環境

  • Tableau Desktop 2020.2.0 and later

解決方法

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
 

原因

User functions cannot be used in a calculation referring fields from different logical tables.
 
這篇文章是否解決了問題?