Opened at, still active after # months

Get Help
1

Hello

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?

2

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.

3

Thanks

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

4

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

5

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