Using Modifiers BY with MINOF

  • 29 September 2022
  • 2 replies

Userlevel 1
Badge +1
  • Enthusiastic Pigmenteer
  • 21 replies



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,




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,


Userlevel 4
Badge +2

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