The screenshot from https://help.salesforce.com/s/articleView?id=001473080&type=1 as below confirms that LOD expression outputs non-aggregated values. But I am confused about the input, I tried nested FIXED LOD in my workbook, such as {FIXED : MAX ({FIXED [Category] : MAX ([Sales])})}, and it worked, so I think the input is also non-aggregated. However, in {FIXED [Category] : MAX ([Sales])}), the MAX([Sales]) serves as the input, which is an aggregated value. So is the input of LOD aggregated or non-aggregated?
@Jian Du
Hi, as you say the result of a fixed expression is not aggregated. Basically you are creating a table. So, let's break it down:
{FIXED [Category] : MAX ([Sales])} basically in SQL is something like:
SELECT [Category], MAX([Sales]) FROM [Your Data] GROUP BY [Category]
In the background this will produce a table like:
Furniture 4416
Office Supplies 9893
Technology 22638
Then, you are using {FIXED : MAX ({FIXED [Category] : MAX ([Sales])})} which will return the MAX of the three values: 22638 = MAX(4416,9893,22638) which also be a table of 1 row.
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
