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