Calculating unique users growth

I am looking for a function to display the growth of unique users., in a line graph.

For example:

Dimension is: ROUND_DAY("_CEL_O2C_ACTIVITIES"."EVENTTIME")

KPI: COUNT(DISTINCT

CASE WHEN "_CEL_O2C_ACTIVITIES"."USER_TYPE" = 'A'

THEN "_CEL_O2C_ACTIVITIES"."USER_NAME" END)

This gives me a number of unique users who performed an activity on that day.

Now I want to for each next day, take the unique users of the day before and add any new unique users for the current day. I was thinking of using MOVING_COUNT and DOMAIN_TABLE but cannot get the query working. Not sure if it even can be done

Page 1 / 1

Yes, you should be able to do something like:

RUNNING_SUM(COUNT ( DISTINCT CASE WHEN "_CEL_O2C_ACTIVITIES"."USER_TYPE" = 'A'

THEN "_CEL_O2C_ACTIVITIES"."USER_NAME" END) ))

Yes, you should be able to do something like:

RUNNING_SUM(COUNT ( DISTINCT CASE WHEN "_CEL_O2C_ACTIVITIES"."USER_TYPE" = 'A'

THEN "_CEL_O2C_ACTIVITIES"."USER_NAME" END) ))

Sorry but explained it not correct. So it should give a count of unqiue users over a period of time. THe above would calculate the unique user for a specific day and sums them all up over the period of time. But this means that the same user can be calculated on different days.

Let's say I go live with a system and want to know the total amount of unique users from day one and see it grow when more new users use the system. The user cannot be counted more than one.

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN