HI @Sravan_Yerupilli -
You can do something like this.
Step 1. Get the date your user first appeared using a LAC-W function
c_first_appeared_dt
minOver(dt,[{user_id}],PRE_AGG)
Step 2. Create a calculated field where if the activity date equals the first appeared then include the user_id
c_new_user
ifelse(truncDate('DD',dt)=truncDate('DD',{c_first_appeared_dt}),{user_id},null)
Step 3. Create a running_sum of the disinct count of c_new_user
c_running_new_users
runningsum(distinct_count({c_new_user}),[dt ASC])
Result:
