Cohort with specific behaviour every month

  • 27 March 2023
  • 1 reply

I would like to create a cohorte of people who performed a certain number of actions per month (like listen to < 20 songs in each month last year). But what if someone listen to 20 songsa month and then 21 in the other one ? In that case I would like to take him out of my cohorte and only keep the people who performed less than 20 songs every month during a year.


Is it possible to get these people in a cohorte ? 


Thanks in advance


Best answer by Saish Redkar 28 March 2023, 00:16

View original

1 reply

Userlevel 7
Badge +10

Hey @Fran6 

I’m not sure if there is a direct way of achieving this constraint without defining the individual clauses for every month and then chaining them for a whole calendar year. Something like this -