retention calculation

[vgadang1]

I have a userID column, date, datemonth, monthnumber, session count, I am trying to create a KPI for total retained users that accessed app (session count) last month and also accessed this month. 

[vinieme12 · Accepted solution]

as below,  not sure what values your datemonth or date field has

I would prefer creating a field with just monthstart or monthend dates to simplify the expression

,monthstart(date) as monthstartdate

and expression as below

=count( {< userID={"=sum({<monthstartdate={"$(=MonthStart(Max(date)))"}>}sessioncount)>0 AND sum({<monthstartdate={"$(=MonthStart(Max(date),-1))"}>}sessioncount)>0"} >} Distinct userID)

This expression is basically filtering userID's with session count>0 in selected/max AND prior month