Loading

Unable to Use a Table Calculation such as RANK() on An LOD (Level of Detail) Calculation

Дата публикации: Apr 13, 2024
Описание
When using RANK() on an LOD calculation, the following error might occur: 
All fields must be aggregate or constant when using table calculation functions or fields from multiple data sources.

Cause

LOD expressions are row level expressions. Like all other row level expressions, they must be aggregated when used in table calculations.
Решение

Option 1

Apply aggregation to the LOD such as RANK(SUM([LoD])). Note, this will aggregate the LoD up to the level of detail of the view.

Option 2

Use the Advanced Partitioning/Addressing of a table calculation to control how the SUM() is computed, instead of using an LOD.
Дополнительные ресурсы
More information about Ranking issues can be found in the Community Forum:
Tableau's Order of Operations
Номер статьи базы знаний

001473116

 
Загрузка
Salesforce Help | Article