KNOWLEDGE BASE

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


Published: 08 Feb 2016
Last Modified Date: 10 Jul 2018

Issue

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.

Environment

Tableau Desktop

Resolution

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.

Cause

LOD expressions are row level expressions. Like all other row level expressions, they must be aggregated when used in table calculations.
Did this article resolve the issue?