Solved

Using Modifiers BY with MINOF

  • 29 September 2022
  • 2 replies
  • 25 views

Userlevel 1
Badge +1
  • Enthusiastic Pigmenteer
  • 21 replies

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'.Date[BY 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

icon

Best answer by Ben 29 September 2022, 23:30

View original

2 replies

Userlevel 4
Badge +2

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

Userlevel 4
Badge +2

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

 

Ben

Reply