Loading

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

Publiseringsdato: Apr 13, 2024
Beskrivelse
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.
Flere ressurser
More information about Ranking issues can be found in the Community Forum:
Tableau's Order of Operations
Knowledge-artikkelnummer

001473116

 
Laster
Salesforce Help | Article