How many times a record that is inside an EnumList is in the table?

AppSheet AppSheet Q&A
1

Dear community, I want to see if anyone knows how to count the number of times a record has been repeated in a table, but that record is in an Enumlist.
Let us suppose the following school situation:
Juan
Peter
Miguel
The three are students who attend the school:

  1. Monday: (John, Peter, Michael) - Enumlist register
  2. Tuesday:(John, Michael)- Enumlist register
  3. Wednesday:(John, Peter)- Enumlist register

How do I calculate how many times it is in the table, for example, Juan. In this case, Juan is three times, Pedro 2 and Miguel 2.

With this I could know how many days in the week each one attended.
I appreciate if you know anything about it, greetings thank you very much in advance.

2

In a table listing the persons, you can add a column with this formula:

COUNT( FILTER(daysTable, IN([_ThisRow].[Name], [enumListRegister])) )

4 Likes
3

This can be achieved with a combination of COUNT() and CONTAINS()

https://help.appsheet.com/en/articles/2347641-count

PS: You may have to do something along the lines of COUNT(Select…

1 Like
4

Magistral amigo, nuevamente dando en la tecla. Tal cual lo expones funciona perfectamente, una calculadora de asistencia. Muchas gracias por tu aporte Joseph!

2 Likes
5

Ryan! muchas gracias por responder! he tomado la solución de Joseph. Intenté probar con las funciones que me dices, pero no he podido resolverlo. Igualmente considera la solución de arriba que anda perfecto. Es una calculadora de asistencias. Saludos. Gracias nuevamente por la respuesta

1 Like
6

CONTAINS() is not a good idea here.

7

That’s right Steve, that’s what I’ve been testing. Contains can lead to an error. I used @Joseph_Seddik 's solution

A big hello to you

1 Like
8

COUNT(select(Table[Name], [Name]=[_ThisRow].[Name]))

This worked for me