Counting distinct values of a text data element

Support - Assistance technique
,
1

If I had text data elements in my event program as shown below for ‘MemberId’ and ‘SessionTitle’, how can I count distinct values of texts entered? For the example below, I would want to count distinct ‘MemberId’ which should result in 2, and distinct count of SessionTitle should result in 3. How can I achieve this? Any help will be appreciated.

my events:
Date, MemberId, SessionTitle, …
2019-09-09, Member1, Growth, …
2019-09-10, Member2, Focus, …
2019-09-11, Member2, Development, …

cc: @jaime.bosque @jthomas
Thank you.

2

Hi @Quoda

You could create a program indicator with an expression similar to this count(distinct #{dataElement}). Please test and see the results. Thanks!

3

6 posts were split to a new topic: Program Indicator to count the total number of options from events in a Tracker Program