![]() This is what is known as an aggregate calculation. ![]() If you drag this calculation to a shelf (or type it directly on a shelf as an ad-hoc calculation), Tableau encloses it in an AGG function: An example of a view-level expression is: In this case, the dimensionality of the expression is view level. If you create a calculation with this definition, save it with the name, and then drag it from the Data pane to a shelf, Tableau typically aggregates the calculated field for the view:īy contrast, expressions referencing aggregated data source columns are computed at the dimensionality defined by the dimensions in the view. For each row, the Sales value in that row will be divided by the Profit value in that row, producing a new column with the result of the multiplication (a profit ratio). This calculation will be evaluated in each row of the database. In this case, the dimensionality of the expression is row level. In Tableau, expressions referencing unaggregated datasource columns are computed for each row in the underlying table. Row Level Expressions and View Level Expressions ![]() For more information about LOD expressions and how they work, see the Understanding Level of Detail (LOD) Expressions (Link opens in a new window) whitepaper on the Tableau website. This article explains how level of detail expressions are computed and how they function in Tableau.
0 Comments
Leave a Reply. |