Fixed Level of Detail Calculations

Fixed level of detail calculated fields are fields that fix an aggregated value to the level of specified dimensions as opposed to the measure being aggregated to the dimensions on the view. Fixed level of detail calculations are written in the following format:

{ FIXED [Dimension1], [Dimension_n] : AGG([field]) }

As many dimension fields as needed can be included before the colon and these will specify the level of aggregation to fix the measure at. If no dimensions are included in the fixed level of detail calculation, then the aggregation will be fixed across the whole dataset.

An aggregation is always required and this can be any aggregation (SUM, AVG, MIN, MAX, and so on) and the field being aggregated does not necessarily have to be a measure. For example, the maximum date per customer could be found and fixed at that level and then used in the view without needing to bring the customer field onto the view.

The fixed level of detail...