Expression to Count ACTIVITIES that Match USEREMAIL

AppSheet AppSheet Q&A
1

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

2

The expression is fine. Please provide a screenshot of the configuration in which you’re using it.

3

Hi Steve,
Here is the result on my app:

3X_d_7_d78d61a144ad8947c9205ac35bbef9715615a667.png

Here is the expression used in the Virtual Column on my Summary Table related to the above:

3X_e_b_ebddf1d714645370d65f7b783fd1eafca187352c.png
3X_e_b_ebddf1d714645370d65f7b783fd1eafca187352c.png716×195 7.71 KB

This is the expression I used in my Virtual Column on the ACTIVITY DATA table

3X_1_7_17383f256eeb816035995840e67ec24352f2aa4e.png
3X_1_7_17383f256eeb816035995840e67ec24352f2aa4e.png1210×465 28.6 KB

Here is the expression used in the ACTIVITY DATA table:

3X_5_4_5439211ce426d089bf9170532d14c8df5f4abf59.png
3X_5_4_5439211ce426d089bf9170532d14c8df5f4abf59.png701×272 12.5 KB

1 Like
4

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

2 Likes