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

[sumawa_quest]

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]

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

[sumawa_quest]

Yes

[sumawa_quest]

Thank you @Aleksi_Alkio. Now its working.

[Aleksi_Alkio]

You’re welcome

[Suvrutt_Gurjar]

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]

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

[Suvrutt_Gurjar]

Hi @Aleksi_Alkio, thank you for your encouraging words.

[sumawa_quest]

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

[sumawa_quest]

oh wait, figured out already. Thanks @Suvrutt_Gurjar

[sumawa_quest]

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]

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]

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.