Loading

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

Publiceringsdatum: Apr 13, 2024
Beskrivning
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.
Lösning

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.
Ytterligare resurser
More information about Ranking issues can be found in the Community Forum:
Tableau's Order of Operations
Knowledge-artikelnummer

001473116

 
Laddar
Salesforce Help | Article