I’m trying to create a dashboard where I want to showcase a KPI value for unique users in a month along with a comparison of unique users for the previous month without repeating users.
Hi @Jane_Onwuchekwa -
Good news, you can do this without any calculated fields using table calculations from the UI.
Example:
You can also use calculated fields for additional customization. Here’s a similar post.
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(…