Hi,
I have an ACTIVITY table and I’m trying count the number of activities that’s associated with USEREMAIL(). I keep getting a list of numbers but I’m looking for a single value. Anyone help with what’s wrong with the below expression? Thanks
COUNT(SELECT(ACTIVITY DATA[ACTIVITY], [EMAIL] = USEREMAIL() ) )
My result is a list like 5, 5, 5, 5, 5, 5, 5, 5,
The result should be a 5.
Let me know what I’m missing in the expression to single out the number.
Thanks
Solved! Go to Solution.
I’ve fixed my problem! Just enter this expression directly into the Summary table:
COUNT(SELECT(ACTIVITY DATA[ACTIVITY], [EMAIL] = USEREMAIL() ) )
I didn’t need this formula ACTIVITY DATA[NUMBER OF ACTIVITIES COMPLETED]. This produced this list, but if I just entered the formulation COUNT, etc, etc. I got the result i’m looking for.
Thanks
The expression is fine. Please provide a screenshot of the configuration in which you’re using it.
Hi Steve,
Here is the result on my app:
Here is the expression used in the Virtual Column on my Summary Table related to the above:
I’ve fixed my problem! Just enter this expression directly into the Summary table:
COUNT(SELECT(ACTIVITY DATA[ACTIVITY], [EMAIL] = USEREMAIL() ) )
I didn’t need this formula ACTIVITY DATA[NUMBER OF ACTIVITIES COMPLETED]. This produced this list, but if I just entered the formulation COUNT, etc, etc. I got the result i’m looking for.
Thanks
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |