FIXED LOD Examples
Customer Order Frequency { FIXED [Customer Name] : COUNTD([Order ID]) } // For each customer, count the unique number of orders { FIXED [Customer Name], [Region] : COUNTD([Order ID]) } // For each customer and region, count the unique number of orders { FIXED [Customer Name], [Region] , [Product Category] : COUNTD([Order ID]) } // For each customer, region and product category, count the unique number of orders Regions per Product { FIXED [Product Name] : COUNTD)[Region]) } // For each product, count the unique number of regions { FIXED []Product Name], DATETRUNC('year', [Order Date]), DATETRUNC('quarter', [Order Date]) : COUNTD([Region]) } // For each product, year and quarter, count the unique number of regions First Order Date per Customer { FIXED [Customer Name] : MIN([Order Date]) } // For each customer, calculate the minimum order date { FIXED [Customer Name], [Region] : MIN([Order Date]) } // For each customer and region, calculate the minimum order date