1
Minimum Date
Hi all,
I'm looking to find the first time a customer quoted. I have a transactional table with customer dimension and a quote date dimension. I want to aggregate the dates by customer and return the minimum date for each customer.
I'd like to create this in formulate so I can calculate different metrics such as date since first quote.
I have tried utilizing the Aggregate Block Minimum function with Quote Date as the data point and customer as the list, the Statistical Minimum function with Quote Date as the data point and customer as the list, and the Aggregation Semantic Minimum function with Quote Date as the measure.
Any insights are appreciated, thank you!