Hi, how do I count the occurrence of 'Visite...

(sumawa quest) #1

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

(Aleksi Alkio) #2

Do you have a separate column with the email address in that table?

(sumawa quest) #3

Yes

(sumawa quest) #4

Thank you @Aleksi_Alkio. Now its working.

(Aleksi Alkio) #5

You’re welcome

(Suvrutt Gurjar) #6

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.

(Aleksi Alkio) #7

It doesn’t matter who is answering if the answer is correct :slight_smile:

(Suvrutt Gurjar) #8

Hi @Aleksi_Alkio, thank you for your encouraging words.

(sumawa quest) #9

Done. How do i call or display the result from the Menu?

(sumawa quest) #10

oh wait, figured out already. Thanks @Suvrutt_Gurjar

(sumawa quest) #11

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?

(Aleksi Alkio) #12

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.

(Suvrutt Gurjar) #13

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.