数据模型
日期表作为维度。
新用户数
AARRR_NewUserCount = // new user count
CALCULATE( COUNTROWS( 'AARRR_User' ) , USERELATIONSHIP( 'Calendar'[CalendarDate] , 'AARRR_User'[ActiveDate] ) )
积累用户数 LTD
AARRR_CumulativeUserCount = // new users count of life-to-date
IF( MAX( 'AARRR_User'[ActiveDate] ) < MIN( 'Calendar'[CalendarDate] ) , BLANK() ,
CALCULATE(
COUNTROWS( 'AARRR_User' ) ,
USERELATIONSHIP( 'Calendar'[CalendarDate] , 'AARRR_User'[ActiveDate] ) ,
FILTER( ALL( 'Calendar' ) , 'Calendar'[CalendarDate] <= MAX( 'Calendar'[CalendarDate] ) )
)
)
网友评论