Solved

# Count total single events by unique property in a time period per user

• 152 views

• New Member
• 0 replies

Hey,

I’m trying to work out if I can understand how many times a single specific event has been fired per user, but only count it once per user based on a unique property.

We have a Course Completed event which has property of Course ID, which determines which course a user has completed.

A user can complete a course multiple times and can also complete different courses.

I’d like a report that shows me the number of times a cohort of users has triggered the Course Completed event in a month, but only count the course completed once based on the Course ID.

Following is an example of individual users and then the required output:

• User A - completed course ID ABCDE = 2 times / completed course ID FGHIJ = 1 time / completed course ID KLMNO = 1 time
• User B - completed course ID ABCDE = 10 times / completed course ID FGHIJ = 6 times / completed course ID KLMNO = 5 times
• User C - completed course ID ABCDE = 10 times / completed course ID FGHIJ = 1 time / completed course ID KLMNO = 0 times
• User D - completed course ID ABCDE = 20 times / completed course ID FGHIJ = 0 times / completed course ID KLMNO = 0 times

The output report would show:

1 user = 1 events / 1 users = 2 events / 2 users = 3 events

Thanks everyone - let me know if any questions

icon

Best answer by Saish Redkar 17 March 2023, 18:03

View original