Opened at, still active after # months


I am trying to build a query showing the percentage of users still active after 3 months.
I have a column "opened at", and a column "closed at"

Would someone be able to assist?

Hi @victoeien
Something like this perhaps?
100 / Count * CountIf(interval([opened at], -3, "month", "include-current") AND isnull([closed at]))
Otherwise try with SQL yourself.


Forgot to mention that i would like it to be detailed per month :slight_smile:

@victoeien Then group by month. Sounds like you are asking for something that would require using SQL instead.

Yeah, tried by month but it does not work.
Thanks anyway!
Will have a look into SQL