Hi, how do I count the occurrence of
‘Visited’ in the column [Visited?]. I want
my apps to count their visit individually (that will be based on Useremail. Tq
Do you have a separate column with the email address in that table?
Yes
Thank you @Aleksi_Alkio. Now its working.
You’re welcome
Hi @Aleksi_Alkio , Apologies
I saw your post in this thread after I posted.
I seem to have an incorrect habit of keeping the post open without refreshing.
It doesn’t matter who is answering if the answer is correct
Hi @Aleksi_Alkio, thank you for your encouraging words.
Done. How do i call or display the result from the Menu?
oh wait, figured out already. Thanks @Suvrutt_Gurjar
Managed to add the virtual column in the slice and tested good. But when I call the slice from the menu, it returned blank. What went wrong?
You probably haven’t changed the source for your view. If you want to use the slice and not the original table, you need to change the source.
Hi @sumawa_quest,I request you to try the following expression in a new virtual column to track
count of visits by an individual based on USEREMAIL()
COUNT(SELECT(TableName[Visitor Email],AND([Visitor Email]=USEREMAIL(), [Visited?]=“Visited”)))
The above expression presumes that the app has table for recording visits such that each row has a [Visitor Email] column that is populated by USEREMAIL() of logged in user [Visited?] column records “Visited” for each visit.
Hope this helps.
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |