Lod function in tableau
Автор: Tableau Dashboard Warriors
Загружено: 2023-10-11
Просмотров: 615
Описание:
Tableau's Level of Detail (LOD) functions are powerful tools for creating advanced calculations and analytics in table format. There are three primary types of LOD expressions:
Fixed: Used to define a specific level of detail regardless of the view, ensuring calculations stay constant. For example, { FIXED [Category] : SUM([Sales]) } calculates the total sales for each category, regardless of the current table or chart view.
Include: These calculations are based on a dimension but include additional dimensions in the view. For instance, { INCLUDE [Region] : AVG([Profit]) } calculates the average profit for each region, incorporating other dimensions on the table.
Exclude: These exclude dimensions from a calculation, allowing users to focus on specific dimensions in the table. For example, { EXCLUDE [Sub-Category] : SUM([Sales]) } calculates total sales excluding sub-categories.
LOD functions enable granular analysis within table formats by controlling the scope of calculations, offering deeper insights into data relationships and patterns.
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: