Forum Discussion

Noredlac86's avatar
Noredlac86
Helper I
4 years ago
Solved

Count repeated values with a condition

Hi Everyone. I waswondering if someone one can help me with this doubt.   I have a table with the name of the employees, and the column, Employe of the month = Yes/No.   I need to count, how man...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    Noredlac86 Maybe:

    How many times column =
  VAR __id = [ID]
  VAR __table = FILTER(ALL('Table'), [ID] = __id && [EMPLOYEEOFMONTH?] = "Yes")
RETURN
  COUNTROWS(__table)