Creating a KPI to compare unique users

[Jane_Onwuchekwa]

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.

[robdhondt]

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.

RunningSum or cumulative total per day having previous users as well

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(…