Skip to main content

Dears,

 

I am trying to get the first Month we have data of a customer to group it by cohort, and I want to add that date as a property of customer.

I was able to get that data using the following formula:

'Requests MRR BE'.DateDBY FIRST: 'Requests MRR BE'.'Company or Partner Id' ]

 

The problem is that it only works as long as I have sort the date ascending in the transaction list, and I would like to retrieve that data without having to sort my transaction list. Is there a way I can integrate MINOF in a modifier so that instead of the first value it finds it takes the smallest?

 

Thank you very much in advance,

 

Jose

Hi Jose!

You were really close, you can use MIN in that case to get the smallest date:

'Requests MRR BE'.Date[BY MIN: 'Requests MRR BE'.'Company or Partner Id' ]

 

Thank you,

Ben

You’ll find the list of all aggregation and allocation methods for the modifier BY in this article: 

 

Ben

Reply


Ask your question here!

Terms & ConditionsCookie settings