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 | |
28 | |
23 | |
16 |