Question
How to COUNT MAX/MIN per one user
+4Hi,
I am trying to solve a case. How to count numbers (MAX and MIN) of events in single KPI. Need to know how many events take on one user.
I have two users. They have different numbers of events min 1 and the other one max 20. I need to make a count of events per user to get max 20 in single KPI.
I tried to use a standard KPI maximum events per case but it is not what i need.
2020-07-30_12-57-17769203 9.74 KB
Hi,
to achieve this, you can use a PU function with a domain table table with which you can first of all count the activities for each user name. You can then use the max statement which gives you the max number of all counted activities for each user:
MAX(PU_COUNT(DOMAIN_TABLE("_CEL_X_ACTIVITIES"."USER_NAME"), "_CEL_X_ACTIVITIES"."ACTIVITY_EN"))
Best regards,
VianaEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.